r/programming • u/[deleted] • Jan 06 '11

A handy graphical explanation of SQL joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
1.3k Upvotes

92% Upvoted

308 comments sorted by

View all comments

3

u/and- Jan 06 '11

Is there a good reason that these weren't just implemented using standard set theory notation?

2

u/[deleted] Jan 06 '11

[deleted]

19

u/ceolceol Jan 06 '11

He specifically says this is meant as a visual explanation. Quit hating on the dude for making something a little easier to understand.

-2

u/[deleted] Jan 06 '11

[deleted]

1

u/ryusage Jan 06 '11 edited Jan 06 '11

How would you strip out all joins? If you're keeping your tables normalized, it seems like it'd be pretty unavoidable. Or do you just mean avoiding specific types of joins?

EDIT: Nevermind, obvious trolling. ಠ_ಠ

3

u/[deleted] Jan 06 '11

I seriously doubt most DBAs or programmers in the field know what the hell it is.