SQL的七种JOIN

#内连接：左表与右表的共有
SELECT <select_list>
FROM tableA A
INNER JOIN tableB B
ON A.key=B.key

#左连接：左表的独有 + 左表与右表的共有（表的行数不同，用null补齐）
SELECT <select_list>
FROM tableA A
LEFT JOIN tableB B
ON A.key=B.key

#右连接：右表的独有 + 左表与右表的共有（表的行数不同，用null补齐）
SELECT <select_list>
FROM tableA A
RIGHT JOIN tableB B
ON A.key=B.key

#左外连接：左表的独有
SELECT <select_list>
FROM tableA A
LEFT JOIN tableB B
ON A.key=B.key
WHERE B.key IS NULL

#右外连接：右表的独有
SELECT <select_list>
FROM tableA A
RIGHT JOIN tableB B
ON A.key=B.key
WHERE A.key IS NULL

#全连接：左表的独有 + 左表与右表的共有 + 右表的独有
SELECT <select_list>
FROM tableA A
FULL OUTER JOIN tableB B
ON A.key=B.key

#交叉连接：左表的独有 + 右表的独有
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