I have two tables Table A and Table B and I want to merge them at runtime by using C#.. For example,
Table A has Two Column ColumnA1 and ColumnA2 and Same as Table B has Two Columns CloumnB1 And ColumnB2. after merage in new Table C the table C will look like this
ColumnA1 -- ColumnA2 -- Column B1 -- Column B2
xyz xyz xyz xyz
xyz xyz xyz xyz
Any brother have any idea about this then please share... I will wait for your cool response. thanks in advance..
mohdazeemuddin ahmedPosted May 23, 2009, 9:41 AM
Hi
use this query
select T1.column1,T1.column2,T2.column1,T2.column2 from table1 T1,table2 T2;
where T1 and T2 are the aliyas of table1 and table2