Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

SQL Update from One Table to Another Based on a ID Match

ayi

<t>SQL Update from One Table to Another Based on a ID Match</t>

ayi

<t>I believe an UPDATE FROM with a JOIN will help:<br/>
<br/>
MS SQL<br/>
<br/>

UPDATE<br/>
    Sales_Import<br/>
SET<br/>
    Sales_Import.AccountNumber = RAN.AccountNumber<br/>
FROM<br/>
    Sales_Import SI<br/>
INNER JOIN<br/>
    RetrieveAccountNumber RAN<br/>
ON <br/>
    SI.LeadID = RAN.LeadID;<br/>
<br/>
```<br/>
<br/>
MySQL and MariaDB<br/>
<br/>
```<br/>
UPDATE<br/>
    Sales_Import SI,<br/>
    RetrieveAccountNumber RAN<br/>
SET<br/>
    SI.AccountNumber = RAN.AccountNumber<br/>
WHERE<br/>
    SI.LeadID = RAN.LeadID;<br/>
<br/>
```</t>