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.noName 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.