UPDATE <table1> 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;