Re: (SQL) UPDATING a table from a join

> Have you tried something like:
>
> update piece
> set level = '02'
> where rowid in ( select a.rowid
> from piece A, piece_list B
> where level = '04'
> and listname = 'TOTO'
> and piece_no = piece_number )
> /
>
> if the count(*) runs fast, then the generation of the set of rowids should be
> fast...

Which means that doing it for every occurence of the first table will yield
acceptable performances....

I did never think of that. Thanks very much for your help!

Best Regards

Emmanuel Baechler
Lausanne
Switzerland Received on Fri Jun 12 1998 - 09:25:08 CEST