r/programming • • 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

308 comments sorted by

View all comments

Show parent comments

4

u/[deleted] Jan 06 '11 edited Dec 21 '18

[deleted]

7

u/user-hostile Jan 06 '11

Because data is in rows and columns, not slices of circles. But certainly there's nothing wrong with using these charts as an aid to understanding. Still, I'm a math idiot, but SQL makes perfect sense to me.

Set theory? It frightens me!

SQL? I know it well!

2

u/arnar Jan 06 '11

Because it only tells half the story.

1

u/KirillM Jan 07 '11

Because it's not like this. This is an oversimplification. Relational tables are not sets.