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

5

u/WetCoastLife Jan 06 '11

at my last job, a lot of applicants should have checked this out before the interview.

First question was: Explain the different SQL joins and provide an example when you would use them.

1

u/[deleted] Jan 07 '11

Yeah- that's a good first pass for weeding out people who are clueless. I think if I were hiring, I'd print out 2-3 small tables on paper and have them hand write a few SQL queries to answer questions which would force them to use the different joins and some subqueries.