User manual

15-12 FileMaker Pro User’s Guide
To import data using a SQL join:
1. In the Specify ODBC SQL Query dialog box, click Clear Query to
remove the SQL statement from the SQL Query box.
2. In the SELECT tab, click the Sales_Data table.
3. Insert the following columns: Company_Name, Amount, and
Salesperson_ID.
4. From the Salespeople table, insert the Salesperson column.
5. Click the WHERE tab to join data from both tables.
6. Verify that the Sales_Data table is showing in the Table list.
The top table is the equivalent of a SQL “left” table; the bottom is the
“right” table.
7. Select Salesperson_ID in the Columns area on the right.
8. The Operator should be displaying an equal sign (=).
9. If necessary, change the bottom table to Salespeople.
10. Select Salesperson_ID in the Columns area on the right.
11. Click Insert into SQL Query.
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.
250 records should be imported into the Sales Reports database.
The SQL query has joined information from the
Sales_Data table and the Salespeople table
Using the WHERE SQL clause
Creating a SQL join