Answers for "psql update with select join"

update with inner join postgres

update xtable x 
set col1 = y.col1
from ytable y 
where y.x_id = x.id;

Posted by: Guest on May-29-2020

Code answers related to "psql update with select join"