SQL Primer

This appendix describes how to use Structured Query Language (SQL) to create recordsets for your dynamic pages. SQL (pronounced sequel) is a language that lets you read and write data from a database. The language has only a few keywords and simple syntax rules, but still allows you to perform sophisticated database operations.

This appendix contains the following sections:

Syntax basics

Defining the columns of a recordset

Limiting the records in a recordset

Sorting the records in a recordset

Joining tables

Related topics

• About databases
• Database design basics
• Understanding recordsets

  NOTE

  Macromedia does not provide technical support for third-party technologies such as SQL.