/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

14 votes201 views2 answers
Oracle add attribute to table
SQL
1 vote197 views1 answer
Order by oracle
SQL
4 votes193 views1 answer
Find tables with column name in sql
SQL
0 vote183 views1 answer
Min and max salary and name in sql
SQL
0 vote199 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote208 views1 answer
Add many column to sap iq table
SQL
0 vote250 views1 answer
Hierarchal database table
SQL
0 vote198 views1 answer
Oracle query archive mode
SQL
3 votes179 views1 answer
Oracle detect invalid password
SQL
0 vote193 views3 answers
Sql delete all except
SQL