SQL - Mixing INNER and OUTER Joins [external link]

When mixing INNER and OUTER joins, it's important to understand the risks involed and this article describe it very clearly:
http://weblogs.sqlteam.com/jeffs/archive/2007/10/11/mixing-inner-outer-joins-sql.aspx