Posted on: 6/29/2015 9:46:54 AM | Views : 691

create table #Student(id int) insert into #student (id) values(1)
create table #Table1(id int,col1 varchar(4)) insert into #Table1(id,col1) values(1,'MD1') insert into #Table1(id,col1) values(1,'MD2') insert into #Table1(id,col1) values(1,'MD3')
create table #Table2(id int,col2 varchar(4)) insert into #Table2(id,col2) values(1,'MD1') insert into #Table2(id,col2) values(1,'MD2')

create table #Table3(id int,col3 varchar(4)) insert into #Table3(id,col3) values(1,'MD1') insert into #Table3(id,col3) values(1,'MD2') insert into #Table3(id,col3) values(1,'MD3') insert into #Table3(id,col3) values(1,'MD4') insert into #Table3(id,col3) values(1,'MD5')
Desired Output
1    MD1  MD1    MD1 1    MD2  MD2    MD2 1    MD3  NULL   MD3 1    Null   NULL   MD4 1    Null   NU ...

Go to the complete details ...