1.取A和B交集
select *
from A
inner join B
on A.key = B.key
2.取A的全部&B与A有交集B的部分
select *
from A
left join B
on A.key = B.key
3.取B的全部&A与B有交集B的部分
select *
from A
right join B
on A.key = B.key
4.取A和B的全部
select *
from A
full outer join B
on A.key = B.key
5.取A中不与B相交的部分
select *
from A
left join B
on A.key = B.key
where B.key is null
6.取B中不与A相交的部分
select *
from A
right join B
on A.key = B.key
where A.key is null
7.取A、B中各自不相交的部分
select *
from A
full outer join B
on A.key = B.key
where A.key is null
or B.key is null