UPDATE JOIN
Версия 1.1 от Alexandr Fokin на 2022/04/26 15:44
update tmpTable1 as t1
set
property1 = dt.property1
from
(
select query...
) as dt
where t1.id = dt.id
set
property1 = dt.property1
from
(
select query...
) as dt
where t1.id = dt.id
How to do an update + join in PostgreSQL?
https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql