日期:2014-05-17 浏览次数:20568 次
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])