I believe an UPDATE FROM with a JOIN will help: MS SQL. UPDATE Sales_Import SET Sales_Import.AccountNumber = RAN.AccountNumber FROM Sales_Import SI INNER ... ... <看更多>

There are quite a few ways to achieve your desired results. Undeterministic methods. (in the event that many rows in table 2 match one in table 1) UPDATE T1 ... ... <看更多>

This video shows the different methods that can be used to update from a select clause in SQL server, specifically how to update from a ... ... <看更多>