Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements

Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements
http://technet.microsoft.com/en-us/library/ms191472%28v=sql.105%29.aspx

Subquery Fundamentals
http://technet.microsoft.com/en-us/library/ms189575%28v=sql.105%29.aspx

SQL Server Join Example
http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/