Adding tables together one under the other.

[thepain009]

I have 4 tables with the same structure and I would like to add them together one below the other. Is there a simple way of doing that?

Thanks in advance,

 

[DotNetGnat]

yes...

SELECT * FROM TABLE1
UNION ALL
SELECT * FROM TABLE2
UNION ALL
SELECT * FROM TABLE3
UNION ALL
SELECT * FROM TABLE4


-DNG

 

[PHV]

Append query ?
Union query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[thepain009]

Thank you both. the UNION ALL statements helped me complete my task.