#1. select * from a join b on a.id = b.id
#2. select * from a inner join b on a.id = b.id
#3. select * from a, b where a.id = b.id
上面的三个是相等的.
#4.剩下的join类型有:
left join
right join
cross join
full join
#5.2005新加
cross apply
outer apply
#2. select * from a inner join b on a.id = b.id
#3. select * from a, b where a.id = b.id
上面的三个是相等的.
#4.剩下的join类型有:
left join
right join
cross join
full join
#5.2005新加
cross apply
outer apply