Get data from 2 tables into a new table to display a list
-
Currently I have 2 tables table A and table B has the same number of columns and data call, absolutely no relationship to each other. (I write in sql server 2005) Example: Table A has 5 rows of data I I Table B has 10 rows of data Now you will create a table C has the same number of columns and data types as table A and Group B Group C I want to get data from 2 tables A and B. And Group C would be 15 rows of data. You do know or did help me through. Thanks in advance home.
-
Currently I have 2 tables table A and table B has the same number of columns and data call, absolutely no relationship to each other. (I write in sql server 2005) Example: Table A has 5 rows of data I I Table B has 10 rows of data Now you will create a table C has the same number of columns and data types as table A and Group B Group C I want to get data from 2 tables A and B. And Group C would be 15 rows of data. You do know or did help me through. Thanks in advance home.
-
use union all
select a.Column1,a.Column2 from TableA a
union all
select b.Column1,b.Column2 from TableB b
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.
Thank you very much.:thumbsup: