/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

1 vote183 views1 answer
Sql bitwise operators
SQL
23 votes194 views4 answers
How to uninstall postgresql in ubuntu
SQL
3 votes237 views2 answers
Enter mysql command line
SQL
2 votes196 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote176 views1 answer
Show specific events on mysql
SQL
0 vote206 views1 answer
Codigo crear tablas sql server
SQL
1 vote195 views1 answer
Vagrant mysql downgrade version
SQL
1 vote179 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote278 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote179 views1 answer
Myswql show full processlist
SQL