Update из Select

В качестве шаблона:

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;