Christof Glaser wrote:[ . . . ]> since the where clause compares just one field for equality. You might> try IN instead of =, ie> > update index set level = 2 where parentid in ( select id from> index where level = 1 );
That was it! Thanks, Frank