• 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!!