How to do UNION of two query results when both results do not have same columns

[Senjalia]

Hi,
Please help me with SQL code that would do Union of two query results NOT having same columns. For example, first result returns columns A,B,C and D and second result returns columns A,B and C. I do not want rows with duplicate values for A, B and C columns.

Result 1:
A B C D
1 2 3 4
1 3 4 5

Result 2:
A B C
1 2 3
7 8 9

Final Desired Result:
A B C D
1 2 3 4
1 3 4 5
7 8 9 NULL

Thanks,
B. Senjalia

[ck9663]

You might need two steps to do this.

1. UNION the table using just those similar columns. You still have to use all column on your first SELECT.

2. Do a JOIN to get the remaining columns. Use all the columns that are the same to relate the unionize table and the tables that you will be getting these value from.

Good luck!

-- CK

[Delerna]

or depending on the complexity of what you are doing
this may be sufficient ?

 select a,b,c,d from result1
 union all
 select a,b,c,null from result2