SQL的联合查询JOIN的七种用法_sqljoin的几种用法

1.概述

可以通过下图直观看出 LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN等相关的7 种用法。

2.语句

以下就是这七种用法的语句：

（1）、Inner JOIN

SELECT <select_list>
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key
1
2
3
4

（2）、Left JOIN

SELECT <select_list>
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
1
2
3
4

（3）、Right JOIN

SELECT <select_list>
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
1
2
3
4

（4）、Outer JOIN

SELECT <select_list>
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key
1
2
3
4

（5）、Left Excluding JOIN

SELECT <select_list>
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
WHERE B.Key IS NULL
1
2
3
4
5

（6）、Right Excluding JOIN

SELECT <select_list>
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL
1
2
3
4
5

（7）、Outer Excluding JOIN

SELECT <select_list>
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL OR B.Key IS NULL
1
2
3
4
5

3.说明

以上的图片以及语句均来自菜鸟教程，略加进行了整理。我们可以看出这七条语句经过图片展示后非常直观的给出了要查询的内容。