Mysql UPDATE, SELECT With SUM

update_select_sum.sql

UPDATE ps_affiliate A
INNER JOIN 
	(
		SELECT id_order, SUM(product_quantity) AS nb_article_order
		FROM ps_order_detail
		GROUP BY id_order
	) B
	ON B.id_order = A.id_order
SET A.nb_article_order = B.nb_article_order

UPDATE ps_affiliate A
INNER JOIN
(
SELECT id_affiliate, MAX(date_add) AS date_lastUpd
FROM ps_affiliate_history
GROUP BY id_affiliate
) B
ON B.id_affiliate = A.id_affiliate
SET A.date_lastUpd = B.date_lastUpd