Re: select & insert

Mauricio Alarcon <malarcon(at)webdepot(dot)com(dot)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.