MySQL的七种JOIN查询

MySQL的 join 查询
注意
1.对查两个表之间的差集，可以用table字段＝null来做。注意千万不是join on XX!=XX。
2.在求全集中，FULL OUTER JOIN在MySQL中是不可以使用的，使用UNION进行组合查询

查询语句(对应上图)：

SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key

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 B.Key IS NULL

SELECT <select_list> FROM TableA A INNER 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 
UNION
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 LEFT JOIN TableB B ON A.Key = B.Key
UNION
SELECT <select_list> FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key