delete from
 EMP
where
 VALID_FLG != '1'
  and
 EMP_CODE in
 (
 select
  EMP_CODE
 from
  EMP_INVALID
 )
;