delete
from
  EMP
where
  VALID_FLG <> '1' and EMP_CODE in (
    select
      EMP_CODE
    from
      EMP_INVALID
  )
;