Combine the result of two tables

Prashant Chaudhary

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
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 Chaudhary15y ago
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 More15y ago
yes prashant...you can add Null as column to match columns of two querys. n then perform Union.
Prashant Chaudhary15y ago
thankx 4 helping me ..bt frnd i don't require a specific coloum .....4 dat purpose i m asking ....
Pravin More15y ago
HI Prashant,
You can use Union to combine two query result..........

        Select * from Table1
           Union
        Select * from Table2

Thanks,
Pravin.