14 Oct 2009 ... Update aa_orders set ordervalue = sum(p.price*oi.quantity) from aa_orders o inner join aa_customers ...
forums.mysql.com