User manual

Using ODBC with FileMaker Pro 15-7
5. If appropriate, enter the user name and password for the data
source you selected, and click OK.
Building a SQL query in FileMaker Pro
Build your SQL query in the Specify ODBC SQL Query dialog box,
which appears after you’ve selected the data source in steps four and
five (above). Start by using the SQL SELECT clause to specify
which tables and columns you want to import.
1. In the SELECT tab, click the table to import in the Tables list.
The columns associated with this table appear in the Columns list box.
2. Select a column to insert into your SQL query and click Insert into
SQL Query.
This constructs the SQL statement in the SQL Query box.
3. Insert additional columns into the SQL query by double-clicking
on the column name.
4. Click the WHERE tab to construct search criteria. This reduces the
number of records that are imported. You can also join data from two
tables.
Select an ODBC data source
Specify the columns from
each table to insert into
the SQL query
As you make choices in
each tab, the SQL query is
automatically generated
Click to add choices into
the SQL query below
Click to execute the SQL query