Need Little Help with Union Query 1

[houstonbill]

I have 2 tables I am trying to joing. tblOpenCases has 32 columns and tblClosedCases has 30 columns, which match 30 of the 32 columns in OpenCases. Without having to spell out all the columns, I first tried the below SQL:

SELECT * FROM tblClosedCases
UNION SELECT * FROM tblOpenCases;

With this I get an error indicating the number of columns do not match. I tried differnt variations but none seem to work. Assistance on getting this to work in the simplest format would be much appreciated.

 

[r937]

if the additional two columns are either at the beginning or end of the table, then you can do this --

SELECT * FROM tblOpenCases
UNION ALL
SELECT null, null, * FROM tblClosedCases

or this --

SELECT * FROM tblOpenCases
UNION ALL
SELECT *, null, null FROM tblClosedCases

otherwise, you will need to list the columns you want, and put NULLs in the appropriate places



r937.com | rudy.ca

 

[houstonbill]

Your first choice worked perfectly, and so simple. Duh, I had not thought of using Null.
Thanks so much for your help.