How can I do an UPDATE statement with JOIN in SQL Server? How can I do an UPDATE statement with JOIN in SQL Server? sql-server sql-server