22,300
社区成员




--我的实际表里有一些其他限制的字段。但是大体意思应该能看出来的
SELECT DISTINCT a.TS_id FROM taskinfo AS a WHERE NOT EXISTS
(
SELECT TR_TSID
FROM tPR_Task_Relation AS c INNER JOIN tPR_Task_Info AS d ON c.TR_FrontID=d.TS_ID
WHERE c.TR_TSID=a.ts_id AND d.TS_StatusID<>2 AND c.SysDeleteSign=0
)