24
SQL JOINs (domesticatedbrain.com)
submitted 3 years ago by to c/programming@programming.dev
4 comments fedilink hide all child comments
 

This explains SQL JOINs which include INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN.

all 4 comments

sorted by: hot top controversial new old
[–] 5 points 3 years ago (1 child)

Venn diagrams are not very good at explaining SQL joins. CROSS JOIN, for example.

https://blog.jooq.org/say-no-to-venn-diagrams-when-explaining-joins/

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
  • [–] 8 points 3 years ago*

    The author does a good job explaining how join diagrams are more accurate than venn diagrams, but by saying that venn diagrams are bad and wrong, I feel like they completely miss the point. The venn diagrams can be understood almost instantly, whereas the join diagrams take time and thought to take in.

    If someone was brand new to sql joins, sure maybe I would say a join diagram is better for them, so they can really understand what is happening. But for someone who just wants a refresher on join types they rarely use, I think the venn diagrams win. I guess ultimately I don't like the claim that one type of diagram is simply "better".

  • permalink
  • fedilink
  • source
  • parent
    • [–] 3 points 3 years ago (1 child)

    Hey…has anyone here ever seen a RIGHT JOIN in the wild?

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •