From: kennedy-downwithspammersfamily@attbi.net   
      
    wrote in message   
   news:Yb9rc.2770$_V4.609@read1.cgocable.net...   
   > (Im a newbie at oracle)   
   >   
   >   
   > I have a field in my database called "gamesplayed" and I would like that   
   to   
   > display the total of 'opwin' & 'oplost' automatically. Sort of like adding   
   a   
   > formula to a field in excel, but I cant figure out how to do this or if   
   its   
   > even possible.   
   >   
   > example:   
   >   
   > 'opwin' 9   
   > 'oplost' 19   
   > 'gamesplayed' 28 (i would like this field to update automatically)   
   >   
   >   
   > I am thinking I just add the command "select sum(opwin+oplost) from   
   > gametable;" to 'gamesplayed', but how?   
   >   
   >   
   > Andrew   
   >   
   >   
      
   You can create a view or use the sql:   
      
   select opwin, oplost, (opwin+oplost) gamesplayed from gametable;   
      
   Unless you built the table with the " around the field names you don't need   
   them.   
      
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)