UPDATE product
SET product.product_code = c.product_code
FROM (
SELECT mm.product_id, product.product_code FROM multiplier_modification mm
JOIN product ON product.product_id = mm.base_product_id) c
WHERE product.product_id = c.product_id