SELECT
 *
FROM
 EMP
WHERE
 EMP.EMP_CODE =
  (SELECT
    EMP_tmp.EMP_CODE
   FROM
    EMP AS EMP_tmp,
    EMP_INVALID
   WHERE
    EMP_tmp.EMP_CODE = EMP_INVALID.EMP_CODE
   )
AND VALID_FLG != '1';