sql 将一个表的数据更新到另一个表(可加减乘除运算)

update 
	A 
SET 
	A.amount = C.amount_sum 
FROM 
	(SELECT 
	    B.a_id AS id ,
	    sum(B.sum) AS amount_sum
    FROM 
	    B
	inner join A on B.a_id = A.id
    GROUP BY 
	    B.a_id
    ) C
WHERE A.id = C.id

需要注意的是:

        1. WHERE A.id = C.id 这里一定得是唯一键,不然会出现奇奇怪怪的问题

        2.sum(B.sum) AS amount_sum 这里可以是别的聚合函数

        3.表关系是 A对B --> 一对多

常用的聚合函数有: