query con left join, sum e group by

[webus]

prova così

SELECT
orderid,
productid,
price_1,
price_2,
price_3,
table_1.productcode,
SUM(price_1) AS totale_price_1,
SUM(price_2) AS totale_price_2,
SUM(price_3) AS totale_price_3
FROM table_1
LEFT JOIN table_2 ON table_1.productid = table_2.productid
WHERE
table_1.productcode LIKE '%stringa%'
GROUP BY
table_1.productcode;