MySQL高级开发--SQL语句中各种JOIN

MySQL高级开发–SQL语句中各种JOIN

标签（空格分隔）： MySQL

---

在查询SQL中，可能碰到各种数据库连接，join。现在做一个总结。
1、

SQL：

SELECT * FROM A,B WHERE A.KEY = B.KEY 
#或者
SELECT * FROM A INNER JOIN B WHERE A.KEY = B.KEY

2、

SELECT * FROM A RIGHT JOIN B WHERE A.KEY = B.KEY 
#或者
SELECT * FROM A,B WHERE A.KEY(+) = B.KEY

3、

SELECT * FROM A RIGHT JOIN B ON A.KEY = B.KEY WHERE A.KEY IS NULL

4、

SELECT * FROM A LEFT JOIN B ON A.KEY = B.KEY 

5、

SELECT * FROM A LEFT JOIN B ON A.KEY = B.KEY WHERE B.KEY IS NULL

6、

SELECT * FROM A  FULL OUTER JOIN B ON A.KEY = B.KEY

7、

SELECT * FROM A  FULL OUTER JOIN B ON A.KEY = B.KEY WHERE A.KEY IS NULL OR B.KEY IS NULL;