This chapter is divided into three sections. The first one focuses on
using the join operation to retrieve data from multiple tables. The
second section covers nesting of queries, also known as subqueries.
The final section introduces several advanced query techniques,
including self-joins, correlated subqueries, subqueries using the
EXIST operator.