Hello, Join!

When I got a job as a database developer in 2002 I found out afterwards that the reason they hired me was because I gave a good answer to the question,

What is the difference between an inner and outer join?

Having just received a technology degree with a course in database design I thought this was a pretty softball question. Fast forward to my 2011 job search. This same question was a part of my technical interview about half of the time. I still think it is an easy question, but it’s good to know that some things don’t change in the technology world.

Simply put, an inner join includes everything in both tables where they match on a column (or columns) and an outer join Continue reading