/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

7 votes224 views4 answers
What is my mysql version
SQL
0 vote223 views1 answer
Allow external access to mysql
SQL
0 vote227 views1 answer
Neo4j command to run script file
SQL
0 vote214 views1 answer
What is SQL data store?
SQL
4 votes219 views1 answer
Oracle delete last row
SQL
4 votes200 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote242 views1 answer
Default order by in mysql
SQL
4 votes294 views2 answers
Delete all table oracle
SQL
0 vote232 views1 answer
Update sql sintax
SQL
0 vote238 views1 answer
Cannot pip install mysqlclient
SQL