/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 vote281 views1 answer
How to find sql server name
SQL
0 vote315 views2 answers
Amazon linux postgresql client
SQL
2 votes289 views1 answer
Find all triggers in database
SQL
8 votes284 views1 answer
Mysql restore database
SQL
0 vote294 views1 answer
Mysql aspas simples
SQL
0 vote409 views1 answer
Postgresql powershell query
SQL
8 votes275 views3 answers
Alter table auto_increment
SQL
10 votes311 views2 answers
Mysql drop database if exists
SQL
1 vote295 views1 answer
Oracle grant select on schema
SQL
1 vote274 views1 answer
Get url of cpanel database hostname
SQL