DELETE
FROM
  EMP
WHERE
  EXISTS(
    SELECT
      1
    FROM
      EMP_INVALID
    WHERE
      EMP.EMP_CODE = EMP_INVALID.EMP_CODE
  )
AND VALID_FLG <> 1
;