Installation and New Features Guide (Windows)

5-4 FileMaker Pro Installation and New Features Guide
Use the Where clause to further narrow down the records being
retrieved. For example, use the greater than (>) operator to return
records where the amount sold is greater than 3,000:
SELECT Sales_data.Company_Name, Sales_data.Amount
FROM Sales_data
WHERE Sales_data.Amount > 3000
You can also reduce the number of records by creating a join with
another column. For more information, refer to the example in
“Specifying a SQL join” on page 5-17.
Use the Order By clause to sort the records before they are imported. To
sort the above records in descending order (from the highest to the
lowest sales amounts) the SQL statement would read:
SELECT Sales_data.Company_Name, Sales_data.Amount
FROM Sales_data
WHERE Sales_data.Amount > 3000
ORDER BY Sales_data.Amount DESC
To create SQL queries in FileMaker Pro, choose Import/Export then
Import Records from the File menu, then the ODBC file format. If the
data source has been configured, you can build your SQL query. Refer
to “Importing from the data source” on page 5-12 for more information.
Building a SQL statement in the FileMaker Pro query builder
Use the Select, Where,
and Order By tabs to build
your SQL query
Make choices above or
type your SQL query
Click to add choices
into the SQL query
below
Click to begin the
SQL query