select * from @left a left join @right b on a.b = b.b
select * from @left a right join @right b on a.b = b.b
select * from @left a inner join @right b on a.b = b.b
select * from @left a full join @right b on a.b = b.b
--左:
select * from @a Aa left join @b Bb on Aa.a=Bb.a
--右:
select * from @a Aa right join @b Bb on Aa.a=Bb.a
--内
select * from @a Aa join @b Bb on Aa.a=Bb.a
--外
select * from @a Aa full join @b Bb on Aa.a=Bb.a
--完全
select * from @a,@b