It isn’t enough to know that Jet SQL’s churning away behind the scenes while you work. To realize the real benefits of having this hitchhiker on board, you need to be able to speak, read, and write SQL. Don’t be intimidated by the prospect of learning SQL—the language is simple and straightforward. In addition, many large databases (Microsoft SQL Server, Oracle and Sybase) use SQL as their primary language, so learning to use Jet SQL in Access now may be to your advantage later. As we learned in Chapter 1 (“Structured Query Language”), SQL’s been around for a while, and it’s cropping up all over the place, so a working knowledge of any SQL dialect is definitely a good skill to acquire.
KeywordsQuotation Mark Statement Select Syntax Error Union Query Distinct Predicate
Unable to display preview. Download preview PDF.