Over a million developers have joined DZone.

An Interactive Reference for Visualizing SQL JOINs

DZone's Guide to

An Interactive Reference for Visualizing SQL JOINs

· Java Zone
Free Resource

Learn how to troubleshoot and diagnose some of the most common performance issues in Java today. Brought to you in partnership with AppDynamics.

JOINs, right? They can be a little tough to think about, especially when you're just starting out with SQL. Jeff Atwood's Venn diagram visualization of how JOINs work - you know, what goes in a LEFT JOIN but not a RIGHT JOIN, that kind of thing - is fairly well-established, but for a quick and interactive variation on the same idea, try this alternative from Patrick Spathon. You have your standard Venn diagrams:

(Source: joins.spathon.com)

But each one can be selected to display a table (along with its null values), the table to JOIN to, and the combined results of the JOIN. It's a great way to learn the difference, or to quickly reference when it's three in the morning and things are just starting to not make so much sense.

Understand the needs and benefits around implementing the right monitoring solution for a growing containerized market. Brought to you in partnership with AppDynamics.


Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}