© 2024 fjorge. All rights reserved.
How do I do a JOIN in an UPDATE with SQL Server

I'm working on some client work on Classic ASP and SQL Server. I needed to do an UPDATE with a JOIN and ran across an issue. As with most things T-SQL, the syntax differs from the ANSI standard. Here's how to do it: