11 Oct 2007 A Visual Explanation of SQL Joins I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing. I love
![A Visual Explanation of SQL Joins](https://cdn-ak-scissors.b.st-hatena.com/image/square/3d25c59d009edfbb2141344708a0034dd5de3be0/height=288;version=1;width=512/https%3A%2F%2Fblog.codinghorror.com%2Fcontent%2Fimages%2Fuploads%2F2007%2F10%2F6a0120a85dcdae970b012877702708970c-pi.png)