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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.