Code: Select all
update tableOne set tableOne.this=blah, tableTwo.that=blah
join tabletwo on tableOne.x = tableTwo.x
where tableOne.id = 5
Moderator: General Moderators
Code: Select all
update tableOne set tableOne.this=blah, tableTwo.that=blah
join tabletwo on tableOne.x = tableTwo.x
where tableOne.id = 5
Code: Select all
UPDATE table_one a, table_two b
SET a.field1 = 'value',
b.field1 = 'value'
WHERE a.id = 'this'
AND b.id = 'that';