Oracle 验证A表的2个字段组合不在B表2个字段组合里的数据
时间：2022-03-14 02:54
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)
时间：2022-03-14 02:54
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)
