[Frej]

UPDATE prod_price,
SET prod_price.Old_ProdPriceEUR = (SELECT tmp_prod_price.Old_ProdPriceEUR
FROM tmp_prod_price
WHERE tmp_prod_price.CompProdID = prod_price.CompProdID
AND tmp_prod_price.ShopID = prod_price.ShopID);