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