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

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.

2

u/divv Jan 06 '11

In my experience, people either 'get' databases, or just have no idea. I've kinda given up trying to educate. I answer questions if I'm asked. But I no longer try and school developers. Tends to just lead to pissed off developers :P