From: s_p_a_m_chris@hotmail.com   
      
   Don,   
      
   Try something like this:   
      
   UPDATE TABLE1   
   SET FIELD1 =   
      (SELECT FIELD2 FROM TABLE2   
       WHERE TABLE2.FIELD2 = TABLE2.FIELD1)   
   ...   
      
      
   --   
   Cheers,   
   Chris   
      
   ___________________________________   
      
   Chris Leonard, The Database Guy   
   http://www.databaseguy.com   
      
   Brainbench MVP for Oracle Admin   
   http://www.brainbench.com   
      
   MCSE, MCDBA, OCP, CIW   
   ___________________________________   
      
   "Don"  wrote in message   
   news:q0j290t74eannlodc70rn7ffenafudnpu8@4ax.com...   
   > Hi,   
   >   
   > I am moving from Sybase to Oracle and I used to be able to do update   
   > statement like this in Sybase:   
   >   
   > UPDATE TABLE1   
   > SET T1.field1 = T2.field2   
   > FROM TABLE1 T1, TABLE2 T2   
   > WHERE T1.field2 = T2.field2   
   > AND ....   
   >   
   > but in Oracle it is not valid. Does anyone know how to convert it to   
   > Oracle?   
   >   
   > Thanks in advance..   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)