Comprehensive explanation of SQL joins(stackoverflow.com)

http://stackoverflow.com/questions/12475850/how-can-an-sql-query-return-data-from-multiple-tables/12475851#12475851