You need a FROM ... clause.
UPDATE products
SET Weight = '0.5' /* is this really a character column? */
FROM products,
rank
WHERE products.code = rank.code
AND category = 'bell';
Unfortunately, it doesn't look as if this syntax is supported
by MySQL (based on a review of the manual and some experimenting).
Bob
-----Original Message-----
From: Ben-Nes Michael [mailto:miki@stripped]
Sent: Monday, September 27, 1999 10:40 AM
To: Mysql
Subject: More Complex UPDATE
Hi
Im trying to:
update products SET Weight="0.5" where (products.code = rank.code) and
category= "bell";
then its says: Unknown table 'rank' in where clause
What can i do to make this UPDATE sucessfull ?
