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