SQL Server Code,Tips and Tricks, Performance Tuning: How to update 2 tables with 1 statement in SQL Server..the hard way....
![SQL SERVER - UPDATE From SELECT Statement - Using JOIN in UPDATE Statement - Multiple Tables in Update Statement - SQL Authority with Pinal Dave SQL SERVER - UPDATE From SELECT Statement - Using JOIN in UPDATE Statement - Multiple Tables in Update Statement - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/updatejoin2.jpg)
SQL SERVER - UPDATE From SELECT Statement - Using JOIN in UPDATE Statement - Multiple Tables in Update Statement - SQL Authority with Pinal Dave
![SQL SERVER - UPDATE From SELECT Statement - Using JOIN in UPDATE Statement - Multiple Tables in Update Statement - SQL Authority with Pinal Dave SQL SERVER - UPDATE From SELECT Statement - Using JOIN in UPDATE Statement - Multiple Tables in Update Statement - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/updatejoin1.jpg)