SQL joins

Please add other helpful links: SQL joins: a visual explanation http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html