IN THIS CHAPTER
Why This Chapter Is Important
Action Queries Queries
Special Query Properties
Optimizing Queries
Crosstab Queries Queries
Outer Joins
Self Joins
Understanding SQL
Union Queries Queries
Pass-Through Queries Queries
The Propagation of Nulls and Query Results
Subqueries
Using SQL to Update Data
Using SQL for Data Definition
Using the Result of a Function as the Criteria for a Query
Passing Parameter Query Values from a Form
Jet 4.0 ANSI-92 Extensions
Practical Examples: Applying These Techniques in Your Application