Introducing SQL and ADO
Structured query language (SQL) is the lingua franca of relational databases, and a solid understanding of it is not optional. SQL is also the ultimate report writer and usually allows you to extract your data exactly in the format that you want it to print. This chapter reviews general SQL syntax and how it varies from one relational database management system (RDBMS) to another. Though most of the SQL examples in this chapter are run against the Northwind database that ships both with Microsoft SQL Server 2000 and Microsoft Access, we’ll also examine dialects of SQL particular to Microsoft Access 2000, Oracle 8, and Sybase 12.
KeywordsStatement Select Structure QuERY Language Aggregate Function Select Country Connection Object
Unable to display preview. Download preview PDF.