delete
from
  EMP
where
  EMP_CODE in (
    select
      EMP_CODE
    from
      EMP_INVALID
  )
;