sql ,表A(ID, Code),表B(ID, Code),删除A中不在B中的记录
发布网友
共2个回答
热心网友
delete from A
where exists(select * from B where B.id=A.id and B.code!=A.dode)
热心网友
delete A from tableA A
where not exists( select 1 from tableB A where (A.ID=B.ID) )
