Dear Neeraj, I have tested that query and with varying inputs. It worked fine in all the situations. The inner query is doing the necessary job. It is bringing out all the dependent records. I wrote the outer query only to satisfy your requirement. But anyways, I enjoyed to solve this kind of queries. By the way, you can always mail me by clicking on the email link provided here in the message section :)
Niladri Biswas
modified on Saturday, June 27, 2009 11:16 PM