JOIN的七种连接

最新推荐文章于 2024-08-19 09:28:34 发布

——Being

最新推荐文章于 2024-08-19 09:28:34 发布

阅读量308

点赞数 1

分类专栏：笔记文章标签： mysql

本文链接：https://blog.csdn.net/weixin_42885595/article/details/108316773

版权

笔记专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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

SELECT * FROM TABLE A RIGHT JOIN TABLE B ON A.KEY = B.KEY

SELECT * FROM TABLE A INNER JOIN TABLE B ON A.KEY = B.KEY

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

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

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

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