This chapter is one of the longest in the book because of the importance of multitable select and aggregate queries in production database applications. Joins are fundamental to relational databases, as Chapter 22, "Exploring Relational Database Design and Implementation," demonstrates. You're likely to find that more than 75% of the queries you create require at least one join, and a substantial percentage need two or more joins.