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/