22,209
社区成员
发帖
与我相关
我的任务
分享
select * from view_UserPager a
left join score b on a.userid=b.userid
left join score c on a.paperid=c.paperid
select * from view_UserPager where UserID in (select userid from score) and PaPerID in (select paperid from score)
2个条件当同时存在这样写就可以
但可能存在score表里PaPerID 有,但UserID 没有的情况
select * from view_UserPager where ltrim(UserID)+'@^#%#*'+ltrim(PaPerID) in (select ltrim(UserID)+'@^#%#*'+ltrim(PaPerID) from score)
select * from view_UserPager where ltrim(UserID)+'@^#%#*'+ltrim(PaPerID) not in (select ltrim(UserID)+'@^#%#*'+ltrim(PaPerID) from score)