SELECT * FROM EMP AS E
-- DELETE FROM EMP AS E
WHERE
  E.EMP_CODE IN (
    SELECT
      EMP_CODE
    FROM EMP_INVALID AS I
  )
  AND
  E.VALID_FLG='0'
;