DELETE FROM EMP_INVALID AS I
WHERE
  I.EMP_CODE NOT IN (
    SELECT
      EMP_CODE
    FROM EMP AS E
    WHERE
      VALID_FLG='1'
  )
;