/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 vote208 views1 answer
Oracle grant on all tables in schema
SQL
0 vote252 views1 answer
How to change mysql root password in windows 10
SQL
2 votes219 views1 answer
Get first n letter of department name in sql
SQL
0 vote261 views1 answer
Python dictionary to sql update
SQL
0 vote215 views1 answer
Cast as decimal postgresql
SQL
2 votes206 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
1 vote213 views1 answer
Show per page table in xampp
SQL
0 vote209 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote230 views1 answer
SAP Return
SQL
0 vote232 views1 answer
Oracle tablespace autoextend
SQL