Understanding INNER JOINS in detail

Hi all.

I just got a link to this nice article about inner joins on SQLServerCentral.com by Susantha Bathige.

The objective of this article is dig into detail of how INNER join produce the result set. The INNER join is the common join type used by many cases. Even though it uses very often I have seen most of them are not certain how it produces the result set when change the joining condition.

To get acces to SQLServerCentral you need to register, but it only takes 20 seconds and you'll get access to really cool stuff.

Hope you like it just as much as I did.