Installation and New Features Guide (Windows)

ODBC import with FileMaker Pro 5-19
12. Click the Order By tab to sort the records before importing them into
FileMaker Pro.
13. Select the name of the column to sort by, Sales_Data.Amount.
14. Click Descending to sort the records from highest amount sold to
lowest amount sold.
15. Click Move.
16. Click Insert into SQL Query.
17. Click Execute.
18. Import the resulting records into FileMaker Pro, as described in
“Importing the results of the query into FileMaker Pro” on page 5-16.
250 records are imported into the Sales Reports database.
Using the Where SQL clause
Creating a SQL join