2022-01-16
閱讀量:
1519
【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;






CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
0條評(píng)論
0條評(píng)論