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)
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)
转载于:https://www.cnblogs.com/wdw31210/p/4118180.html