跟上一个差不多 update tt_temp_equ_workrate set (design_capa,capa_xs )=(select nvl(b.desi_prod_capa,0),nvl(c.coeff,0) from sb_equi_acc a,sha.sb_model_cd b,sha.sb_jldw_cd c where a.mdl_id = b.sys_id_key and b.capa_unit_id = c.sys_id_key and a.id_key = tt_temp_equ_workrate.equi_id);
update tt_temp_equ_workrate
set (design_capa,capa_xs )=(select nvl(b.desi_prod_capa,0),nvl(c.coeff,0)
from sb_equi_acc a,sha.sb_model_cd b,sha.sb_jldw_cd c where a.mdl_id = b.sys_id_key and
b.capa_unit_id = c.sys_id_key and
a.id_key = tt_temp_equ_workrate.equi_id);