假设存在A表、B表,且A、B表有公共部分,存在以下七种连接:
- 内连接:select * from A inner join B on A.key=B.key;
- 左连接:select * from A left join B on A.key=B.key;
- 右连接:select * from A right join B on A.key=B.key;
- A-公共部分:select * from A left join B on A.key=B.key where B.key is null;
- B-公共部分:select * from A right join B on A.key=B.key where A.key is null;
- 全部(去重):select * from A left join B on A.key=B.key union select * from A right join B on A.key=B.key;
- 全部-公共: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;