发布网友
共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) )