delete from EMP 
where
  VALID_FLG = '0' and
  exists(
    select 1 from EMP_INVALID b
    where
      EMP_CODE = b.EMP_CODE
  )