update t_ifm_bizdealbill_deposit_e te set fsourcebillno = (select tcd.fbillno from t_ifm_bizdealbill_deposit tibd left join t_cim_depositapply tcd on tibd.fapplyid = tcd.fid
where tibd.fid = te.fid and tibd.fapplyid != 0) 
where fsourcebillno is null or fsourcebillno = ' ' and exists (select tcd.fbillno from t_ifm_bizdealbill_deposit tibd left join t_cim_depositapply tcd on tibd.fapplyid = tcd.fid
where tibd.fid = te.fid and tibd.fapplyid != 0);
