22,210
社区成员
发帖
与我相关
我的任务
分享
inner join frm_zbd on not exists (
select * from frm_xzxksltzs where frm_xzxksltzs.slbh not in (select frm_zbd.slh from frm_zbd)
)
select *
from frm_xzxksltzs
where not exists (select 1 from frm_zbd where frm_xzxksltzs.slbh =slh)
--?
select *
from frm_xzxksltzs
where frm_xzxksltzs.slbh not in (select frm_zbd.slh from frm_zbd)