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;

Leave a Reply

Your email address will not be published. Required fields are marked *