A great visual explanation of SQL joins on Coding Horror, a rewrite of Lig’s awesome post: “Getting” Joins
Before you think about sending an email “hey, can you optimize my query”, please read this article and make sure you’re using your joins as expected.
Also, yay Venn diagrams!
