You are looking for a "UNION"
SELECT [GROUP] AS 'Group',
[ID] AS 'Id'
SELECT [SectionGroup] AS 'Group',
[PartID] AS 'Id'
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'
SELECT [SectionGroup], [PartId]
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.