/SQL/Copy from one table to another postgres using matching column

Copy from one table to another postgres using matching column

UPDATE Table2 --format schema.table_name
SET 
ref_id2 = table1.ref_id1
FROM table1 -- mention schema name
WHERE table1.id = table2.id
AND 
table1.a_ref1 = table2.b_ref1;

Source: stackoverflow.com

Similar codes

0 vote350 views1 answer
Mysql update even / odd rows
SQL
0 vote336 views1 answer
Left join in codeigniter query builder
SQL
10 votes346 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote342 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote351 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
14 votes351 views4 answers
Online sql compiler
SQL
0 vote347 views1 answer
Mssql now diff 90 day
SQL
0 vote339 views1 answer
Soql last week
SQL
3 votes344 views1 answer
Oracle revoke
SQL
6 votes357 views2 answers
Non relational database
SQL