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.