摘要： select id, name from TAB_A t where not exists (select 1 from TAB_B t1 where t.id = t1.id and t.name = t1.name) 阅读全文