Re: Urgent Fetch and updation in single step/query

Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. -- Regards Abhishek Jain On 4/20/06, abhishek jain

Re: Urgent Fetch and updation in single step/query

WEBBEE . BIZ wrote: Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. Hmm should work with PROCEDURE