From: wit@dba.kiev.ua   
      
   Hello, michael,   
      
   About 02:20 01-Jul from michaelnewport@yahoo.com accepted:   
      
   > in Ingres I can do this   
   >   
   > update table1 from table2   
   > set table1.field = table2.field   
   > where table1.id = table2.id   
   >   
   > is there an equivalent in Oracle ?   
      
   update table1   
   set field = (   
   	select field   
   	from table2   
   	where table2.id = table1.id   
   );   
      
   --   
   wbr,   
   Wit.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)