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?
After thinking it a little more, of course you can't because there's nothing to join on! brain-cramp
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.
Just a second, they *do not* say you can update several tables with one statement.
Originally Posted by swdev
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.