tsql - Update a table using JOIN in SQL Server? - Stack Overflow

2009年10月21日 - UPDATE table1 a INNER JOIN table2 b ON a.commonfield = b. ... You don't quite have SQL Server's proprietary UPDATE FROM syntax down.

stackoverflow.com