Installation and New Features Guide (Windows)

ODBC import with FileMaker Pro 5-17
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.
Use the ODBC example files, along with these procedures, to create a
report that lists sales information for each salesperson.
Note Before importing ODBC data, you must specify the ODBC driver
and data source in the ODBC control panel as described in “Configuring
the ODBC control panel” section from page 5-7 to page 5-12.
The SQL query has joined information from the Sales_Data table and the Salespeople table