MYSQL一目了然 JOIN 图

1 Join图

①A B共有

select<select_list> from TableA A inner join TableB B on A.key=B.key;

②A B共有A全有,

select<select_list> from TableA A left join TableB B on A.key=B.key;

③A B共有B全有

select<select_list> from TableA A right join TableB B on A.key=B.key;

④A B共有A独有

select<select_list> from TableA A left join TableB B on A.key=B.key where B.key is null;

⑤A B 共有B独有

select<select_list> from TableA A right join TableB B on A.key=B.key where A.key is null;

⑥A B全有

select<select_list> from TableA A full outer join TableB B on A.key=B.key;

⑦A B独有

select<select_list> from TableA A full outer join TableB B on A.key=B.key where A.key is null or B.key is null;