Introducing SQL and ADO
Carl Ganz · Apress eBooks · 2003
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. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.