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