/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 votes235 views3 answers
SQL trim
SQL
0 vote212 views1 answer
How to run mysql in git bash
SQL
0 vote202 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
21 votes202 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote192 views2 answers
How to get json data mysql
SQL
0 vote203 views1 answer
How to query all tables mysql at the same time
SQL
0 vote195 views1 answer
Get all employees if name ends with in sql
SQL
21 votes258 views3 answers
Average sql
SQL
0 vote365 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote238 views1 answer
Creating sqeuence in oracle database
SQL