SQL joins explained as Venn diagrams

A handy illustration explaining how left and right joins work in SQL, presented as Venn diagrams.

For some examples with actual data, check also this article by Jeff Atwood

h/t Ilya Grigorik, Data Visualization (on G+)

Posted on May 30, 2013 by Markos Giannopoulos in Web Development

Tags: MySQL, databases, SQL