CODE EXAMPLE FOR SQL

postgresql update between 2 tables

UPDATE table_1 
SET column_one = table_2.column_one,
    column_two = table_2.column_two
FROM table_2
WHERE table_1.orderno = table_2.orderno