В качестве шаблона:
UPDATE
dummy
SET
customer=subquery.customer,
address=subquery.address,
partn=subquery.partn
FROM (
SELECT
address_id,
customer,
address,
partn
FROM /* big hairy SQL */ ...
) AS subquery
WHERE
dummy.address_id=subquery.address_id;