You cannot update multiple tables in a single UPDATE.
Did you read the manual?
-Original Message-
From: Javier Armendáriz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 2:04 PM
To: MySQL
Subject: What is wrong in this query???
Can someone tellme the problem in this query??
At 21:03 +0100 3/27/02, Javier Armendáriz wrote:
>Can someone tellme the problem in this query??
>
>Is there any problem updating two tables in the same query???
Do you find that syntax to be allowed anywhere in the MySQL manual?
There is work on this kind of thing being done for MySQL 4.1.