psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

 

There are 5 types of join in sqlserver
cross join
inner join
left outer join
right outer join
full outer join

cross join
select * from table1
cross join table2
cross join table3
cross join table4
inner join
select * from table1
inner join table2
on table1 .c1=table2.c1
inner join table3
on table2 .c1=table3.c1
inner join table4
on table3 .c1=table4.c1

replace inner join with left outer join/right outer join/full outer join as per requirement