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.
Why is it 'not enough' -- does it not work for you?
But I agree, that it would be very good to extend the UPDATE syntax to
allow for joins, too!
Regards,
Martin
--
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826 E4EC 8058 7B31 3AD7
