purushottam2 (3/7/2013)
May i know the cause?
The cause is present in the link provided by Chris earlier in the thread and also provided below
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/