From: don_leeNO_aa_SPAM@telus.net   
      
   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)