It isn't possible for SQL queries to update a database table. However perhaps you just needed to see a computed value as one of the columns in your result? You can certainly do that, supposing of course that the condition you're basing the calculation on is something that can be evaluated from other data in the tables you're querying.
Although your example is sort of confusing -- your description of your requirements refers to several columns which we can't see in your query.
posted 2 years ago
Yes my requirement is little complicated.
Anyway I am working on query let see if get any success in that.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads