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)
2021-12-10 23:39:35
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)
下一篇:面向对象之abstract