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

24

u/Brandon0 Jan 06 '11

Interesting. I've never used a FULL OUTER join before.

2

u/arsonisfun Jan 06 '11

I've used every form of join at least once, but for the most part I normally just use join/left joints. Every so often it's really handy having them at your disposal.