Updating multiple tables
Posted: Fri Aug 04, 2006 3:18 am
Is there a way to perform an update on more than 1 table at a time? Something similar to a JOIN?
Code: Select all
update tableOne set tableOne.this=blah, tableTwo.that=blah
join tabletwo on tableOne.x = tableTwo.x
where tableOne.id = 5