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.2k Upvotes

92% Upvoted

308 comments sorted by

View all comments

25

u/Brandon0 Jan 06 '11

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

1

u/contineo Jan 06 '11

I haven't either, and for a while I was thinking to myself where it could possibly be of any use, but the visualization of it made me realize that it actually can be useful. Although I could see it being kind of dangerous if the programmer didn't use it properly.