http://www.databasejournal.com/features/mssql/article.php/3623916/MS-SQL-Joins-Part-2.htm

http://www.databasejournal.com/features/mssql/article.php/3630381/MS-SQL-Joins-Part-3.htm

article1.sql

article2.sql

article3.sql

joinexamples.sql