User manual

Using ODBC with FileMaker Pro 15-11
5. Leave the user name and password blank and click OK.
Specifying the SQL query in FileMaker Pro
Start your SQL query with the SQL SELECT tab to specify what data
you want to extract from the data source.
1. If there is a SQL statement in the SQL Query area, click Clear Query.
2. In the SELECT tab, click the Salespeople table.
3. Select the Salesperson ID column, then click Insert into SQL Query.
4. Insert the following columns by double-clicking the column
name: Salesperson, Sales_Manager, and Sales_Region.
5. Click Execute. The Import Mapping dialog box appears. For more
information on importing records, see “Importing data into
FileMaker Pro” on page 12-2.
Importing ODBC data with a join
Use the WHERE tab in the FileMaker Pro query builder to create a
multi-table SQL query, or join. A join combines data from two or
more tables into a new table.
Specifying a SQL join
In this example, we want to view a report that contains information
about sales transactions (from the Sales_Data table), along with
information about the salesperson (from the Salespeople table). To
ensure that the data is combined in a meaningful way, you should
link the two tables with a matching field.
Because both tables in the ODBC example files contain the
Salesperson_ID column, we can create a variety of reports by doing
a join on the Salesperson_ID column.
Select the ODBC
data source you
previously configured
Specify columns to insert
in the SQL query
The SQL query is
automatically generated
Click to add statements