15. Querying with SQL Statements
IN THIS CHAPTER
Using SQL to Perform a Select Query
Using SQL to Perform Action Queries
Using SQL to Create Subqueries
Using SQL to Create Union Queries
When you build an Access query, what you’re really doing is building a Structured Query Language (SQL) statement. In other words, the Query Design view is just a front end to help you construct an SQL (pronounced ESS-kew-ell, although many people say it as SEE-kwul) statement without having to know anything about SQL syntax.
Fortunately, in a business context the majority of query needs are adequately fulfilled using the Design view (or even one of the query wizards), so business users don’t often need to learn SQL. However, ...
Get Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries 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.