???Multiple table update???

[Guest_imported]

I need to update several tables where the same condition is met.

Ex. Update 1, 2, 3 Set Number = Number + 1 where
"THIS IS WHERE I GET LOST"
condition = same in all tables

I have tried severeal different ways with no luck. I believe my concept is correct, just lacking very much in the syntax department.

Thanks in advance for any help.

Mark

 

[foxdev]

The UPDATE command only takes one table at a time as an argument.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[jazerr]

Just do it like this

UPDATE MyTable
Set MyField = MyField + 1
Where MyField Like '%jazz'
GO
UPDATE MyTable1
Set MyField1 = MyField1 + 1
Where MyField1 Like '%jazz'
GO
UPDATE MyTable2
Set MyField2 = MyField2 + 1
Where MyField2 Like '%jazz'
GO