UPDATE products p,( SELECT products_id, sum(attributes_stock) as mysum FROM products_attributes GROUP BY products_id) as s SET p.products_quantity = s.mysum WHERE p.products_id = s.products_id