Yes its not working :-(
bkline wrote:
> 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 ?
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--------------------------
