More Complex UPDATE

[Ben-Nes Michael]

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: [phone]
Fax: [phone]
http://www.canaan.co.il
--------------------------