594
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 100
WP.* ,
JS.ISRemember
FROM JobSheet js
LEFT JOIN WProcess wp ON wp.JobSheetNo = js.SheetNo
WHERE ISNULL(ISRemember, 0) = 1
AND NOT EXISTS ( SELECT 1
FROM WProcess wp
WHERE wp.JobSheetNo = js.SheetNo
AND ProcessNo = 1
AND wp.StationID <> '01' )