This blog post is an introduction to joins.