/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

1 vote364 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote342 views1 answer
Oracle right characters
SQL
0 vote357 views1 answer
Sql dmv to capture updates
SQL
0 vote353 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
3 votes338 views1 answer
Show index table
SQL
1 vote350 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote374 views1 answer
Adding primery key constraint to a column
SQL
0 vote373 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote347 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote363 views1 answer
Oracle dynamic select into
SQL