删除b表中与a表不同的记录
delete from b where not exists(select * from a where a.id=b.id and a.name=b.name)
delete from b where b.id not in (select a.id from a) or b.name not in (select a.name from a)
删除b表中与a表不同的记录
delete from b where not exists(select * from a where a.id=b.id and a.name=b.name)
delete from b where b.id not in (select a.id from a) or b.name not in (select a.name from a)