Hi all,
I need do a update from t1 set col='P' where int_art = (SELECT int_art from
t2 ).
I know that thios sentence is not correct but I'd like do the update for
everethigs rows that return the select.
Is it posible?
Tk very much
Jose Antonio
-Mensaje original-
De: [EMAIL PROTE
Hi!
I have a doubt, I have somethigs same this...
init transaction
update from tabla1 set estado=1 where art=0;
update from tabla1 set estado=estado+1 where estado=1
final trasaction
The second update take the first updates if we are in the same transaction?
Tk
-