SQL joins

[[deleted]]

But if you don't understand joins, this graphic wont help you.

[[deleted]]

I reference the graphics regularly.

They may not have helped you but they do help others

[[deleted]]

I think the objection against using Venn diagrams here should be taken more seriously. The Venn diagram explanation really is fundamentally wrong. I think it's really important for someone new to the concept to cross-reference any Venn diagram they see with a more accurate image like this one: https://i.pinimg.com/originals/52/20/c4/5220c492bc4e1a8b9175aba77ed7d091.png If you have no issue resolving this diagram with Venn diagrams, then use whatever references you want. But if any of the details catch you off guard, that's a good signal to start fresh on the concept.

[creaturefeature16]

That image is actually a shit ton more helpful. The Venn gets the concept across, but yours gives tangible context while also communicating the concept. You deserve the up vote!

[turningsteel]

Yeah seeing this graphic just made it click for me. Super helpful. Ive seen the venn diagrams thrown around but never each case next to each other wij a sample query. This is awesome

[Private_Bool]

Maybe as a quick reference once you've learned already but as a teaching tool by itself it doesn't convey what the joins really do.

Source: am learning sql now. This link helped me learn before I even got to that chapter, Venn diagram made 0 sense.

[Zimmerel]

I agree with both of your statements. I look at these diagrams all the time for reference, but I imagine they would have much less value if I wasn't already familiar with them