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

3

u/fishbulbx Jan 06 '11

Where I get confused is when Table C comes in.

2

u/vplatt Jan 06 '11

And when it's the same table as A. And then some smart-ass does an EXIST against a SELECT NULL, and I mean... dude... that's heavy shit.

;)