22,209
社区成员
发帖
与我相关
我的任务
分享
;with cte as
(
select b.handlsh,b.mpsid from Prodinout as a inner join Prodinoutlist as b on a.matioid=b.matioid
)
select * from Feizailist as a where not exists(select 1 from cte where handlsh=a.handlsh and mpsid=a.mpsid)