/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 vote279 views1 answer
Get statis values sql
SQL
1 vote286 views1 answer
Floor function in sql oracle
SQL
0 vote284 views1 answer
Make parameters nullable in sql server
SQL
2 votes250 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote297 views1 answer
Dual in db2
SQL
0 vote271 views1 answer
Select sql in descending order
SQL
0 vote256 views1 answer
Mysql search multiple tables
SQL
0 vote272 views1 answer
Oracle drop type
SQL
0 vote259 views1 answer
Connecting mySQL to STS
SQL
49 votes306 views6 answers
Mysql add column to table
SQL