--将一张表中的一列数据的总和 赋值给另一张表的字段
update scm_pay_apply o set o.settlement_money = (
select
sum(ad.settlement_money) as 明细结算汇总
from scm_pay_apply pa
left join scm_pay_apply_detail ad on pa.id = ad.pay_apply_id
where o.id = pa.id
)
where o.entity_code in (
select
pa.entity_code
from scm_pay_apply pa
left join scm_pay_apply_detail ad on pa.id = ad.pay_apply_id
group by pa.entity_code,ad.settlement_id,pa.settlement_money
having pa.settlement_money <> sum(ad.settlement_money)
)