Hey Roy

Thank you for the reply. I am clear on the subject of primary keys now. I guess i still have to do some reading to be fully aware...

Thank you for the reply. I implemented your example and was able to see the difference.

I am aware of the diff between clustered and non-clustered but i dont know...

Thanks a ton Gail. your solution made it so much easier !!! I appreciate it !! Thank you !

hey guys,

Thank you for responding so fast. the inner join works perfectly.

can you also tell me how the query will look if its on a different server, for...

they are on the same server and this is what i tried. i am getting a result but its gibberish!! i am just starting off sql so may be i...