Gail, Chris
Thanks a ton.
I will go with queru 1, even if there is no performance gain.
One last qerry you may like to help on:
If I use query 2/3, then optimizer must be converting it in Inner Join before execution. If I'm right then is there any way I can find out the diferrence between Query I wrote and Query sql executed!!