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+)

Tags: databases, MySQL, SQL

This entry was posted on Thursday, May 30th, 2013 at 11:46 am and is filed under Web Development.