Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to merge several tables together

Author  Topic 

ashley.s
Starting Member

9 Posts

Posted - 2011-11-27 : 05:11:55
Hello All,
I have several sql scripts that create tables. I need to put all the records in one table only. Any command to do that?
Thanks,
Ashley

vikki.seth
Yak Posting Veteran

66 Posts

Posted - 2011-11-27 : 06:34:58
Try with using SQL joins.
http://beginner-sql-tutorial.com/sql-joins.htm
Go to Top of Page

Kyle Doouss
Yak Posting Veteran

64 Posts

Posted - 2011-11-27 : 14:57:36
If I have understood you right you could use an Union All

Select Field1,Field

from Table1

Union All

Select Field1,Field

from Table2


Go to Top of Page
   

- Advertisement -