FIX FILE2.txt
| 1 |
SELECT * FROM CM_ATTACH_FILE A WHERE A.REF_MASTER IN ( |
|---|---|
| 2 |
SELECT caf.REF_MASTER FROM CM_ATTACH_FILE caf |
| 3 |
LEFT JOIN PL_REQUEST_DOC_FILE prdf ON caf.REF_ID = prdf.PL_REQUEST_DOC_FILE_ID |
| 4 |
WHERE caf.PATH_NEW = '' |
| 5 |
AND caf.TYPE = 'PL_REQUEST_DOC_FILE' |
| 6 |
AND prdf.PL_REQUEST_DOC_FILE_ID IS NOT NULL AND prdf.PL_REQUEST_DOC_FILE_ID <> '' |
| 7 |
GROUP BY caf.REF_MASTER |
| 8 |
) ORDER BY A.REF_MASTER DESC |