UPDATE T1 SET T1.PRICE = (SELECT PRICE FROM (SELECT ID, SUM(PRICE) PRICE FROM T2 GROUP BY ID) T2 WHERE T1.ID = T2.ID);COMMIT;
