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.
| Author |
Topic |
|
noblemfd
Starting Member
38 Posts |
 Posted - 2012-02-20 : 16:12:44
|
| Am developing an application with mssql 2000, with multiple tables, the same column names, but different data. Please how do I merge these tables. See belowTABLE1Name | Age | SexAde | 20 | maleFemi | 15 | male TABLE2Name | Age | Sexkola | 22 | femalejide | 41 | male TABLE3Name | Age | SexTAde | 22 | maleDEJI | 15 | female RESULTName | Age | SexAde | 20 | maleFemi | 15 | male kola | 22 | femalejide | 41 | male TAde | 22 | maleDEJI | 15 | female |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-20 : 16:30:19
|
| use UNION ALL or UNION------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Multiple tables