/SQL/Update sql server from another table

Update sql server from another table

UPDATE t1
SET t1.column = t2.column
FROM Table1 t1 
INNER JOIN Table2 t2 ON t1.id = t2.id;

Source: stackoverflow.com

Sql update from different table

-- SQL Server
UPDATE Sales_Import
SET Sales_Import.AccountNumber = RAN.AccountNumber
FROM Sales_Import SI
INNER JOIN RetrieveAccountNumber RAN
ON SI.LeadID = RAN.LeadID;
-- MySQL & MariaDB
UPDATE Sales_Import SI, RetrieveAccountNumber RAN
SET SI.AccountNumber = RAN.AccountNumber
WHERE SI.LeadID = RAN.LeadID;

Source: stackoverflow.com

Similar codes

0 vote141 views1 answer
Create mysql pool connection python flask
SQL
0 vote144 views1 answer
How to reset the database value in SQL server
SQL
0 vote242 views1 answer
How to use select union and loop
SQL
0 vote123 views2 answers
Mysql unique two columns
SQL
7 votes134 views3 answers
Sql get last inserted row
SQL
0 vote153 views1 answer
Oracle execute immediate quotes
SQL
12 votes213 views4 answers
How to drop all tables in postgresql
SQL
17 votes143 views4 answers
Postgres list users
SQL
0 vote140 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote159 views1 answer
Mysql dump with table query
SQL