Database Reference
In-Depth Information
When you extract data from
most
databases (FileMaker being the notable exception), you
have to use a special programming language called Structured Query Language, or SQL (of-
ten pronounced
sequel
). Writing a SQL
query
(or program) is a complicated affair. Luckily,
in most cases, FileMaker can do it for you—you just make the right choices. (For more de-
tail, see the box on the facing page.)
When you're all finished building your query, click Execute. FileMaker performs the query,
gathers the data from the data source, and shows the same Import Field Mapping dialog box
you always see when importing data. If you find yourself doing a lot of ODBC imports, you
may be well served by a good topic on SQL.