can you UPDATE two tables in a single SQL statement using INNER JOIN for two tables

As I undertstand INNER JOINs, once joined they are like one big table. So Can you UPDATE or INSERT two (or more) tables in a single SQL statement using INNER JOINs?

Thanks.

first edit
========================================
After thinking it a little more, of course you can't because there's nothing to join on! brain-cramp

For UPDATES

Short answer - YES

Long answer - http://dev.mysql.com/doc/mysql/en/UPDATE.html

For INSERTS - No

No, you can't.
You can only ever modify (update, delete, insert) one table at a time.

Quote:

---

Originally Posted by swdev

For UPDATES

Short answer - YES

Long answer - http://dev.mysql.com/doc/mysql/en/UPDATE.html

For INSERTS - No

---

Just a second, they *do not* say you can update several tables with one statement.

Multi-Table updates do not update multiple tables!
They are used only to return a subset of the table containing the rows to be modified based on the join.