Re: Inserting and Referencing In the same Query

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 27 Feb 2006 02:51:14 -0800
Message-ID: <1141037474.636646.168510@i40g2000cwc.googlegroups.com>

Thanks for the reply Rama, but in our case we dont have any option for using any triggers.
I mean we have to just use a query in which a value has to be inserted based on the value inserted in the previous column.

About details, we have this table which has several columns. I have to insert a value into a column based on a value of another column which I inserted previously in the same query.

eg: If the columns are like Id and say salary. I am inserting a value into column Id say 1 and then i want to check the values in the Id column before i start inserting values in salary column.

I hope i am making myself clear.

TIA Received on Mon Feb 27 2006 - 04:51:14 CST