根据图片顺序来看
1、内连接(查询a,b公有部分)
select * from a inner join b on a.key=b.key;
2、左连接(查询a,b共有部分以及a独有的部分)
select * from a left join b on a.key=b.key;
3、右连接(查询a,b共有部分以及b独有的部分)
select * from a right join b on a.key=b.key;
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、全连接(a,b全部,mysql不支持full,使用union进行去重连接,将左连接和右连接用union连接起来)
select * from a left join b on a.key=b.key
union
select * from a right join b on a.key=b.key;
7、a独有+b独有(将图4和图5使用union连接)
select * from a left join b on a.key=b.key where b.key is null
union
select * from a right join b on a.key=b.key where a.key is null;