asked on
SQL - Appending data from another table with different column names
how can i append data from another table with different column names..
Table 1: Table 2:
Group ID SectionGroup PartID
-------- -------- ---------------- -----------
100 A 300 C
200 B
Expected Result:
Group ID
------- -----
100 A
200 B
300 C
Table 1: Table 2:
Group ID SectionGroup PartID
-------- -------- ---------------- -----------
100 A 300 C
200 B
Expected Result:
Group ID
------- -----
100 A
200 B
300 C
Microsoft SQL Server
Last Comment
Scott Pletcher
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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