delete from EMP
where EMP_CODE in (
select
  EMP_CODE
from
  EMP_INVALID as main
where not exists (
    select 1 from EMP b
    where b.VALID_FLG <> '1'
     and main.EMP_CODE = b.EMP_CODE
  )
)