Navigate
X

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

Tags: databasesMySQLSQL
Markos Giannopoulos:
Related Post
  1. Machine Learning in everyday applications

    Machine Learning has been around for decades and is already used in a variety of…

  2. Pleasing our Lord Google: A work in progress

    Improving the Core Web Vitals metrics does not seem to have any serious effect in…

  3. SWDchallenge: A low carb story

    The theme of this month's Storytelling with Data challenge is "artisanal data". E.g. data collected…