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 |
mosiki
Starting Member
12 Posts |
Posted - 2013-06-21 : 06:36:51
|
HiI have two tables with the exact same layout (column wise), and would like to show all data from two tables as one result set.Table A has 581 RowsTable B has 80 RowsI need the result set to show selected columns with all 661 rows of data. there are no primary keys in any of the two tables. Number of columns and column names are exactly the same.Many ThanksMosiki. |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-21 : 06:41:17
|
SELECT Column-list FROM Table1UNION ALLSELECT Column-list FROM Table2--Chandu |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-21 : 06:41:48
|
SELECT Column-list FROM Table1UNION ALLSELECT Column-list FROM Table2--Chandu |
|
|
|
|
|