/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 vote133 views1 answer
How to update date value in sql
SQL
0 vote123 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote128 views1 answer
Window function mysql
SQL
0 vote133 views1 answer
Mysql sql.gz
SQL
3 votes129 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
5 votes122 views1 answer
Invalid column name sql
SQL
0 vote134 views3 answers
Query string not ending with with vowels
SQL
0 vote142 views4 answers
What is unique key in sql
SQL
-1 vote172 views1 answer
Minus vs except in sql
SQL
0 vote127 views1 answer
Sqlalchemy.exc.OperationalError:
SQL