Menu

A currated repository of web design tools and resources that I use...

MySQL Joins Explained

March 13, 2015 - MySQL
MySQL Joins Explained

I use joins ALL the time, yet I still get twisted up sometimes. I keep this webpage in my favorites as a visual reminder to get me straightened out.

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.

 

Categories: MySQL  Tags:

Daniel Posted by

Leave a Reply

Your email address will not be published. Required fields are marked *