Oracle 验证A表的2个字段组合不在B表2个字段组合里的数据

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)

  

上一篇:stm32串口接收发送数据处理


下一篇:面向对象之abstract