A simple yet effective page explaining SQL joins using Venn Diagrams: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx?msg=2919743 a very handy site to have around when learning about JOINs.