delete from EMP as main
where main.EMP_CODE in (
  select
    1
  from
    EMP_INVALID as x
  where
        x.EMP_CODE = main.EMP_CODE
    and ifnull(x.VALID_FLG, '') <> '1'
)