34,590
社区成员
发帖
与我相关
我的任务
分享
select * from [ur_logs_dl]
where [coltdid] = 'XXXXX'
and not exists (select * from [ur_logs_done] where fid = [ur_logs_dl].id)
select * from [ur_logs_dl]
where [coltdid] = 'XXXXX'
and id not in (select fid from [ur_logs_done])