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 sql