Just fyi, you don't need the column names on the second(+) query in a UNION, SQL uses the names from the first query. This is fine:
SELECT [GROUP] AS 'Group',[ID] AS 'Id'
FROM dbo.Table1
UION
SELECT [SectionGroup], [PartId]
FROM dbo.Table2
Just fyi, you don't need the column names on the second(+) query in a UNION, SQL uses the names from the first query. This is fine:
SELECT [GROUP] AS 'Group',[ID] AS 'Id'
FROM dbo.Table1
UION
SELECT [SectionGroup], [PartId]
FROM dbo.Table2