Answers for "UPDATE table inner join pgsql"

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 "UPDATE table inner join pgsql"