Mysql学习笔记（2）- 常见通用JOIN查询

1. 左连接 left join (A所有,包含与B的交集)

select * from A
left join B on A.key = B.key
-- 结果 = A所有+AB交集

2. 右连接 right join (B所有,包含与A的交集)

select * from A
right join B on A.key = B.key
-- 结果 = B所有+AB交集

3. 内连接(交集)： inner join (A和B的共有部分，即交集)

select * from A
inner join B on A.key = B.key
-- 结果 = AB交集

4. A独有

select * from A
left join B on A.key = B.key
where B.key is null

5. B独有

select * from A
right join B on A.key = B.key
where A.key is null

6. 外连接 （AB并集）

select * from a
full outer join b on a.key = b.key

7. 外连接 （AB差集）

select * from a
full outer join b on a.key = b.key
where a.key is null or b.key is null