Thanks for the reply.

I've achieved the same with the help of 2 select statements but not able to do so with one select statement in a string query.. My friend...