DELETE FROM EMP
WHERE
EMP.EMP_CODE IN (SELECT EMP_INVALID.EMP_CODE
 FROM EMP_INVALID
 LEFT JOIN EMP ON EMP.EMP_CODE = EMP_INVALID.EMP_CODE
 )