So far, this book has covered topics such as regular expressions, aggregates, and joins. These powerful SQL features allow the construction of complex queries. In some cases, however, even these tools may prove inadequate. This chapter shows how SELECTs can be combined to create even more powerful queries.