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.
J. Grohmann, D. Seybold, S. Eismann, M. Leznik, S. Kounev, und J. Domaschka. 2020 28th International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS), Seite 1--8. IEEE, (November 2020)Acceptance Rate: 27%.
S. Eismann, C. Bezemer, W. Shang, D. Okanovic, und A. van Hoorn. Proceedings of the 2020 ACM/SPEC International Conference on Performance Engineering (ICPE), (April 2020)Acceptance Rate: 23.4% (15/64), ACM Artifacts Evaluated — Functional.
J. von Kistowski, S. Eismann, N. Schmitt, A. Bauer, J. Grohmann, und S. Kounev. Proceedings of the 26th IEEE International Symposium on the Modelling, Analysis, and Simulation of Computer and Telecommunication Systems, Seite 223--236. IEEE Computer Society, (September 2018)Acceptance Rate: 29.5\% (23/78).
S. Eismann, J. Grohmann, E. van Eyk, N. Herbst, und S. Kounev. Proceedings of the 2020 ACM/SPEC International Conference on Performance Engineering (ICPE), Seite 265--276. New York, NY, USA, Association for Computing Machinery (ACM), (April 2020)Acceptance Rate: 23.4% (15/64).
J. Grohmann, P. Nicholson, J. Iglesias, S. Kounev, und D. Lugones. Proceedings of the 20th International Middleware Conference, Seite 149--162. New York, NY, USA, Association for Computing Machinery (ACM), (2019)
S. Eismann, J. Walter, J. von Kistowski, und S. Kounev. 2018 IEEE International Conference on Software Architecture (ICSA), Seite 135-144. (April 2018)Acceptance Rate: 25,6\% (22/86).