2008年10月22日 - I believe an UPDATE FROM with a JOIN will help: UPDATE Sales_Import SET Sales_Import.AccountNumber = RAN.AccountNumber FROM ...
stackoverflow.com