且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

比较sql中的2个表

更新时间:2023-12-01 10:53:04

搜索A1表中存在但A2表中不存在的记录:

Search for records that exist in A1 table but not in A2 table:

SELECT * FROM A1 WHERE NOT EXISTS (SELECT * FROM A2 WHERE A2.Id = A1.Id)