SELECT caf.* FROM CM_ATTACH_FILE caf
LEFT JOIN PL_REQUEST_DOC_FILE prdf ON caf.REF_ID = prdf.PL_REQUEST_DOC_FILE_ID
WHERE caf.PATH_NEW = ''
AND caf.TYPE = 'PL_REQUEST_DOC_FILE'
AND prdf.PL_REQUEST_DOC_FILE_ID IS NOT NULL AND prdf.PL_REQUEST_DOC_FILE_ID <> ''