ORG_NAME = @ORG_NAME from table1 A inner join table2 B on B. SQL JOINS But this is a really hacky parlor trick, use the transaction and multiple updates, it's much more intuitive. You can update a table based on a join, you just can't have the update affect multiple tables. You can then update the View which will then update the underlying tables.Tweet Sometimes, when searching for an answer, we end up making things too much complicated, while easy solutions are just round the corner.
You can wrap your around your more than one UPDATE statement in a single transaction, this way if one or more statement fails, the entire transaction rolls back.If not, I would love to know the reason, you want to update two more tables in a single statement. SQLAuthority.com)I’m stunned that this needs discussing in 2017.There’s probably an article from 20 years covering this.There are some questions where the answer is no and that is totally fine.I often get asked that as it is possible to select two or more tables in a single SELECT statement, is it possible to UPDATE more than one table in a single table.