From: julia.sats@sympatico.ca   
      
   What wrong with such query:   
      
   update MY_TABLE   
   set FIELD_ONE = 'A'   
   where FIELD_TWO in (select FIELD_TWO   
                      from MY_TABLE   
                      where rownum < 11   
                      order by FIELD_THREE )   
      
   The query return such error:   
   ORA-00907: missing right parenthesis   
      
   I know that the problem because of the "order by" but why?   
      
   And if I need to update only specify portion (for example first 10 records)   
   what to do?   
   I can use PL/SQL , cursor , but can I do using single query?   
      
   Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)