Just found below article from Gail on the same 🙂
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂