delete from EMP 
where exists (
  select
  1
  from
  EMP a
  ,EMP_INVALID b
  where 
  a.EMP_CODE = b.EMP_CODE 
  AND a.VALID_FLG != '1'
);