17,086
社区成员
发帖
与我相关
我的任务
分享
select a.* from a, b
where a.agent_id = b.agent_id (+)
and b.rowid is null;
和
select * from a
where not exists(select 1 from b
where agent_id=a.agent_id)
select * from a
where agent_id not in (select agent_id from b);
select * from a
where not exists (select 1 from b where agent_id=a.agent_id);
select a.* from a, b
where a.agent_id = b.agent_id (+)
and b.rowid is null;