Postgres allows:
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;
This syntax is not standard SQL
Created at Sapientia University, Tirgu Mures (Marosvásárhely), Romania. Directed by Kátai Zoltán and Tóth László. In cooperation with "Maros Művészegyüttes",...
Este artigo tem como principal interesse ajudar estudantes que tenham interesse em trabalhar com banco de dados, aprendendo o principal comando: SELECT.
S. Eismann, L. Bui, J. Grohmann, C. Abad, N. Herbst, and S. Kounev. Proceedings of the 22nd International MIDDLEWARE Conference, page 248–259. (2021)Best Student Paper Award, ACM Artifacts Evaluated — Functional.
V. Lesch, T. Noack, J. Hefter, S. Kounev, and C. Krupitzer. Proceedings of the 2nd IEEE International Conference on Autonomic Computing and Self-Organizing Systems - ACSOS 2021, IEEE, (2021)Best Paper Award Runner Up, Full Paper Acceptance Ratio: 25%.
V. Lesch, M. Hadry, S. Kounev, and C. Krupitzer. Proceedings of 3rd International Workshop on Pervasive Computing for Vehicular Systems (PerVehicle), 2021, IEEE, (March 2021)