Forming Complex Queries

The situations covered in this section are more technical than most end users have need to conceptualize. However, a system administrator may require such complex query structures to efficiently obtain the desired results.

• Joining a Table to Itself
• Correlated Subqueries
• Subquery Using EXIST