Installation and New Features Guide (Windows)

5-18 FileMaker Pro Installation and New Features Guide
To access the FileMaker Pro query builder, choose Import/Export then
Import Records from the File menu, then the ODBC file format. Refer to
“Importing from the data source” on page 5-12 for more information.
To do a join:
1. In the Specify ODBC SQL Query dialog box, click Clear Query to
remove the SQL statement from the SQL Query box.
To confirm that you want to delete the query, click Clear.
2. In the Select tab, click the Sales_Data table.
The columns associated with the Sales_Data table appear.
Select the Company_Name column, then click Insert into SQL Query.
3. Insert the following columns into the SQL query by double-clicking
the following column names: Amount and
Salesperson_ID.
4. From the Salespeople table, insert the Salesperson column.
5. Click the Where tab to join data from both tables.
You also specify search criteria in the Where tab.
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 box 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 box on the right.
11. Click Insert into SQL Query.