ADVANCED QUERIES

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.

• Retrieving Data From Multiple Tables
  • Command Discussion
• Nesting Queries
  • Command Discussion
• Forming Complex Queries
  • Joining a Table to Itself
  • Correlated Subqueries
  • Subquery Using EXIST
• Virtual Fields
• Column Aliasing