postgresql update with inner join and case statement code example
Example: update with inner join postgres
update xtable x
set col1 = y.col1
from ytable y
where y.x_id = x.id;
update xtable x
set col1 = y.col1
from ytable y
where y.x_id = x.id;