
delete from A left join B on A.GUID=B.GUID where B.GUID is null
不考虑性能就用IN咯,比上一条要短一点
delete from A where GUID not in (select GUID from B)

delete from A left join B on A.GUID=B.GUID where B.GUID is null
不考虑性能就用IN咯,比上一条要短一点
delete from A where GUID not in (select GUID from B)