/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 vote105 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote100 views1 answer
Inserting data into different tables at once in oracle sql
SQL
2 votes110 views1 answer
Use cases condition in sql query laravel
SQL
58 votes257 views6 answers
Create new user in postgres
SQL
0 vote105 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote106 views1 answer
Example of sql querry result sepapreted by comma
SQL
3 votes102 views2 answers
Oracle for loop
SQL
1 vote96 views1 answer
Mysql show current queries
SQL
0 vote113 views1 answer
Mysql custom sort order
SQL
0 vote117 views1 answer
Alter fedora mysql 8.0 user
SQL