[GENERAL] Update from select??

2003-07-03 Thread jose antonio leo
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

[GENERAL] update innside transactions?

2003-07-28 Thread jose antonio leo
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 -