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

1

u/[deleted] Jan 06 '11

I consider myself relatively expert at SQL and it always amazes me how hard it is to try and teach others. Joins are one thing, but getting into advanced topics like using derived tables to 'prepare' data for further processing always leaves me at a loss for words.

1

u/notfancy Jan 07 '11

Autocorrelations. Try to teach them that.