update بر اساس select در mysql

[sql]
Update
nodes as C
inner join (
select sum(amount) as total , user_id from bimeh_commission group by user_id
) as A on C.user_id = A.user_id
set C.total_amount = A.total
[/sql]