-- 8.16 vector."TB_NZYSJ_NEW" vector."AFTER_NZYSJ_NEW" vector.gdbh_zbph --8.13 UPDATE base.t_jsc_sql SET jsc_sql='SELECT round(coalesce(sum(zy_gdmj),0),2)zy_gdmj,round(coalesce(sum(zy_st),0),2) zy_st,round(coalesce(sum(zy_cn),0)/1000,2) zy_cn, round(coalesce(sum(cb_gdmj),0),2) cb_gdmj,round(coalesce(sum(cb_st),0),2) cb_st,round(coalesce(sum(cb_cn),0)/1000,2) cb_cn, #{id} as id ,#{begin_time} as create_time FROM vector.gdbh_zbph x where xzqhdm like #{id}||''%'' AND pzrq >= #{begin_time} AND pzrq < #{end_time}' -- 同步数据 -- base.t_fzss_fzxz_factor_temp -- base.t_fzss_fzxz_factor