24
SQL JOINs (domesticatedbrain.com)

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

top 4 comments
sorted by: hot top controversial new old
[-] chahk@beehaw.org 5 points 1 year ago

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/

[-] calabast@lemm.ee 7 points 1 year ago* (last edited 1 year 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".

[-] CodeBlooded@programming.dev 3 points 1 year ago

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

[-] livingcoder@programming.dev 2 points 1 year ago* (last edited 1 year ago)

When I see a RIGHT JOIN I just shake my head and wonder "Why?". That said, I can't remember the last time I saw one.

load more comments
view more: next ›
this post was submitted on 02 Aug 2023
24 points (77.3% liked)

Programming

17314 readers
88 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 1 year ago
MODERATORS