http://stackoverflow.com/questions/44917/explicit-vs-implicit-sql-joins
http://www.bennadel.com/blog/284-sql-optimization-and-on-clause-vs-where-clause.htm
http://stackoverflow.com/questions/354070/sql-join-where-clause-vs-on-clause
http://www.programmerinterview.com/index.php/database-sql/inner-vs-outer-joins/
http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins
LEFT OUTER JOIN vs LEFT JOIN
http://www.dofactory.com/sql/left-outer-join
http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server