SELECT 1 AS TAG, NULL AS Parent, ID AS [i!1!id], company AS [i!1!c], place AS [i!1!p], street AS [i!1!s], zipcode AS [i!1!z], telefax AS [i!1!tf], telephone AS [i!1!t], email AS [i!1!e], url AS [i!1!u], SiteDescription AS [i!1!sd], OpenTimeMo AS [i!1!omo], OpenTimetu AS [i!1!otu], OpenTimewe AS [i!1!owe], OpenTimeth AS [i!1!oth], OpenTimefr AS [i!1!ofr], OpenTimesa AS [i!1!osa], OpenTimesu AS [i!1!osu], SiteAbstract AS [i!1!sa], NULL AS [b!2!id], NULL AS [b!2!rid], NULL AS [b!2!pos] FROM dbo.companies WITH (NOLOCK) WHERE (ID = 879806) UNION ALL SELECT 2 AS TAG, 1 AS Parent, InfoID AS [i!1!id], NULL AS [i!1!c], NULL AS [i!1!p], NULL AS [i!1!s], NULL AS [i!1!z], NULL AS [i!1!tf], NULL AS [i!1!t], NULL AS [i!1!e], NULL AS [i!1!u], NULL AS [i!1!sd], NULL AS [i!1!omo], NULL AS [i!1!otu], NULL AS [i!1!owe], NULL AS [i!1!oth], NULL AS [i!1!ofr], NULL AS [i!1!osa], NULL AS [i!1!osu], NULL AS [i!1!sa], BranchenID AS [b!2!id], RegionID AS [b!2!rid], RelPosition AS [b!2!pos] FROM dbo.companies_positions WITH (NOLOCK) WHERE (InfoID = 879806) FOR XML EXPLICIT