一张图看懂 SQL 的各种 JO〓〓〓〓̳〓IN 用法
[导读]：下图展示了 LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN 相关的 7 种用法。 Inner JOIN SELECT select_list FROM Table_A A INNER JOIN Table_B B ON A . Key = B . Key Left JOIN SELECT select_list FROM Table_A A LEFT JOIN...
下图展示了 LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN 相关的 7 种用法。
Inner JOIN
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key
Left JOIN
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
Right JOIN
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
Outer JOIN
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key
Left Excluding JOIN
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
WHERE B.Key IS NULL
Right Excluding JOIN
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL
Outer Excluding JOIN
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
更多内容可以参考 SQL 教程
本文来自投稿，不代表微盟圈立场，如若转载，请注明出处：https://www.vm7.com/a/ziyuan/112126.html
