>>>>> "Martin" == Martin Ramsch <m.ramsch@stripped> writes:
Martin> On Tue, 1999-10-05 13:43:13 +0200, Ben-Nes Michael wrote:
>> Hi I wanted to do :
>> UPDATE products SET Weight = '0.5' FROM products, rank WHERE
>> products.code = rank.code AND category = 'bell';
>> And got answered that its impossible and all I can do is first do a
>> select then update the results.
>> This is a good solution only when i mange few items, but when i get back
>> hundreds of items its not enough.
Martin> Why is it 'not enough' -- does it not work for you?
Martin> But I agree, that it would be very good to extend the UPDATE syntax to
Martin> allow for joins, too!
I agree. This isn't really that complicated to do and this has quite
high priority for us.
(DELETE with joins is also very important and even easier to implement)