Thanks all of you to look into the matter. I am feeling very strange to say that without doing anything the query is running perfectly which was annoying me a lot.

Mr.Hilmar can u let me know how can I replace this query with JOIN command.

Thanks/Regards

Saif