Re: select & insert

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.