Update multiple tables

[Mike Blezien]

Hello,

I'm alittle unclear on how too update multiple tables. We have two tables with 
the same column name:
account.state
account_service.state
when we update the account table, we also need to update the account_service 
table with the same value for the 'state' column. Can this be done with MySQL 
4.1.12. and what is the correct syntax?


Thx's
Mickalo 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]