Combine the result of two tables

Question

hi ... required help urgently I want to combine the result of two tables ....bt don't require 1 specific coloum to get combine with them .... wat query i should use for it.... plz rpy ASAP.....

Suthish Nair · Answer

Prashanth, Actually your question is not clear. While asking questions show us with sample data, as what output you are expecting. Am not sure, something like this? select 1 'Sr.No', 'Name1' 'Name', 11 'Class' into #T1 union all select 2, 'Name2', 22 union all select 3, 'Name3', 33 select 1 'Sr.No', 'Name9' 'Name', 99 'Class' into #T2 union all select 2, 'Name8', 88 union all select 3, 'Name7', 77 select t1.[Sr.No], t1.Name '#T1_Name', t2.Name '#T2_Name', t1.Class '#T1_Class', t2.Class '#T2_Class' from #T1 t1 inner join #T2 t2 on t1.[Sr.No] = t2.[Sr.No] --drop table #T1 --drop table #T2

Prashant Chaudhary · Answer

No buddy I think you are not getting my query .actually in my table1 there are 3 coloums like Sr.no. , Name and Class and in case of table2 coloums are like Sr.no,Name and Class .. But i don't want to combine the coloum Class...... for this purpose what I have to do ?

Pravin More · Answer

yes prashant...you can add Null as column to match columns of two querys. n then perform Union.

Prashant Chaudhary · Answer

thankx 4 helping me ..bt frnd i don't require a specific coloum .....4 dat purpose i m asking ....

Pravin More · Answer

HI Prashant, You can use Union to combine two query result.......... Select * from Table1 Union Select * from Table2 Thanks, Pravin.

Combine the result of two tables

Answers (5)