How to append four tables? 1

[katrina11]

Hello Experts!

I have just faced problem of concantenating four tables with the same structure. Table1
Table2
Table3
Table4

I need the table named combined. How can I do it in SQL Server 2005?

Thank you!

Katrin

 

[Qik3Coder]

katrina11,
We're (go borg!) going to need more detail to help you with this one.

Do you need to have the table structures of all 4 tables be the same, or do you need to combine the information in all 4 tables into 1 new table?

Thanks,
Lodlaiden

You've got questions and source code. We want both!

 

[drlex]

Of course, if it's just a data-dump, one can use UNION ALL

SELECT * INTO Combined FROM
(SELECT * from Table1
UNION ALL
SELECT * from Table2
UNION ALL
SELECT * from Table3
UNION ALL
SELECT * from Table4)T1

soi là, soi carré