Results 1 to 4 of 4
Jan 5, 2005, 10:22 #1
- Join Date
- Dec 2004
- 0 Post(s)
- 0 Thread(s)
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
Jan 5, 2005, 10:27 #2
Jan 5, 2005, 10:34 #3Originally 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.
Jan 5, 2005, 10:28 #4
No, you can't.
You can only ever modify (update, delete, insert) one table at a time.