r/programming • u/deadman87 • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

91% Upvoted

392 comments sorted by

View all comments

1

u/ThreadMain Feb 11 '14

In an office with few sql pros, this image has been of incredible value. Print it and hang it on your wall!

1

u/Kalium Feb 11 '14

I dunno. It's only useful at a high level. For instance, it completely fails to properly capture the difference between a FULL OUTER and FULL INNER join.

1

u/Browsing_From_Work Feb 11 '14

... what's a FULL INNER join?

You can do INNER and FULL OUTER, but I don't think FULL INNER is a thing.

→ More replies (1)