SQL update from one Table to another based on a ID match

SQL update from one Table to another based on a ID match

MS SQL

UPDATE
 Sales_Import
SET
 Sales_Import.AccountNumber = RAN.AccountNumber
FROM
 Sales_Import SI
INNER JOIN
 RetrieveAccountNumber RAN
ON
 SI.LeadID = RAN.LeadID;
MySQL and MariaDB

UPDATE
 Sales_Import SI,
 RetrieveAccountNumber RAN
SET
 SI.AccountNumber = RAN.AccountNumber
WHERE
 SI.LeadID = RAN.LeadID;



http://www.stackofcodes.in/2017/12/05/sql-update-one-table-another-based-id-match/