Thread

1. select & insert

   Mauricio Alarcon <malarcon@webdepot.com.co> — 2000-12-13T21:17:59Z

   How I can make an update to a register from a select query?
   I have this
   
   update table1 set r1=(select r1+1 from table1);
   
   I don't knok how to do this, please help!
   
   Thanks
   		Mauricio Alarcon
   
   
   

2. Re: select & insert

   Arcady Genkin <a.genkin@utoronto.ca> — 2000-12-20T18:33:28Z

   Mauricio Alarcon <malarcon@webdepot.com.co> writes:
   
   > How I can make an update to a register from a select query?
   > I have this
   > 
   > update table1 set r1=(select r1+1 from table1);
   
   Try this:
   
   update table1 set r1=(select T1.r1+1 from table1 T1);
   
   Note that if there is more than one row in the table1, then you might
   want to limit the select clause by some condition.
   -- 
   Arcady Genkin
   Don't read everything you believe.