1、INNER JOIN (内连接) 2、LEFT JOIN (左连接) 3、RIGHT JOIN (右连接) 4、OUTER JOIN (外连接) 5、LEFT JOIN EXCLUDING INNER JOIN (左连接排除内连接结果) 6、RIGHT JOIN EXCLUDING INNER JOIN (右连接排除内连接结果) 7、OUTER JOIN EXCLUDING INNER JOIN (外连接排除内连接结果) 原文章地址链接 https://juejin.im/entry/5bd676b351882527792d0997?utm_source=gold_browser_extension#comment