试试这样
update hml_test_table set
ced=(SELECT
(select sum(nvl(SUBCONTRACTING_FEE, 0)) from statements_all_cost_item
where province = '吉林' and now_month='201310' )
+
(select nvl(SUB, 0) from statements_project_cost
where province = '吉林' and now_month=to_char(to_number('201310')-1) and status = 'Q1')
FROM dual
);
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024