2022-01-16
阅读量:
1403
【SQL】使用LEFT JOIN子句求表1与表2的差集
SELECT tbl_1.column_1, tbl_1.column_2, ..., tbl_1.column_k, ..., tbl_1.column_n FROM tbl_1 LEFT JOIN tbl_2 ON tbl_1.column_public = tbl_2.column_public WHERE tbl_2.column_any IS NULL;






推荐帖子
0条评论
0条评论
1条评论