It was a good article, however these are fundamental types of joins. I would like to have seen something on hash joins and merge joins.