A表 B表 C表
根据B表 C表 更新A表Sum中的数据
update A set Sum=newSum from A
inner join (select B.BillNum,SUM(Price) as newSum
from B inner join C on B.TiaoMa=C.TiaoMa group by b.BillNum)as D
ON A.BillNum=D.BillNum
A表 B表 C表
根据B表 C表 更新A表Sum中的数据
update A set Sum=newSum from A
inner join (select B.BillNum,SUM(Price) as newSum
from B inner join C on B.TiaoMa=C.TiaoMa group by b.BillNum)as D
ON A.BillNum=D.BillNum