Chapter 23. Working with Structured Query Language
This chapter describes Structured Query Language (SQL), the structure and syntax of the language, and how Access translates queries you design with Access's graphical query-by-example (QBE) technique into SQL statements. A SQL background helps you understand the query process and design more efficient queries. Knowledge of SQL syntax is necessary to use the new sub-query and UNION query capabilities introduced by Access 2.0 and for many of the applications you write in Access VBA. Examples of SQL have been presented in other chapters in this book. These examples—usually figures that illustrate a SQL statement created by Access—demonstrate what occurs behind the scenes when you create a query ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
