左链接，右连接

最新推荐文章于 2023-12-22 12:59:31 发布

scan724

最新推荐文章于 2023-12-22 12:59:31 发布

阅读量638

点赞数

分类专栏： sql cookbook

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/33316109

版权

sql cookbook 专栏收录该内容

59 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

本文介绍了SQL中的三种连接操作：左连接、右连接和全连接。通过创建并演示两个表格`L`和`R`的数据，展示了不同连接方式在数据匹配时的效果。左连接显示了所有左表（L）的记录，即使在右表（R）中没有匹配项；右连接则显示所有右表的记录；全连接则同时显示左右表的所有记录，无论是否存在匹配。

摘要由CSDN通过智能技术生成

/*左表*/
CREATE TABLE L AS
SELECT 'left_1' AS str,'1' AS v FROM dual UNION ALL
SELECT 'left_2','2' AS v FROM dual UNION ALL
SELECT 'left_3','3' AS v FROM dual UNION ALL
SELECT 'left_4','4' AS v FROM dual;
/*右表*/
CREATE TABLE R AS
SELECT 'right_3' AS str,'3' AS v,1 AS status FROM dual UNION ALL
SELECT 'right_4' AS str,'4' AS v,0 AS status FROM dual UNION ALL
SELECT 'right_5' AS str,'5' AS v,0 AS status FROM dual UNION ALL
SELECT 'right_6' AS str,'6' AS v,0 AS status FROM dual; 

SQL> select * from l;

STR    V
------ -
left_1 1
left_2 2
left_3 3
left_4 4

SQL> select * from r;

STR     V     STATUS
------- - ----------
right_3 3

了解本专栏