update t_ifm_intbill_batch_int as t set ftextdebtor = (select t1.ftextdebtor from t_cfm_loanbill_e as t1 where t1.fid = t.floanbillid and t1.ftextdebtor is not null)
where exists (select fid from t_cfm_loanbill_e as t3 where t3.fid = t.floanbillid and t3.ftextdebtor is not null);