Extract Data from Multiple Tables using a JOIN
You can extract data from multiple tables using a JOIN command in your SQL statement.
This example shows how to configure the connector to retrieve data from both the Items and Products tables of an example database:
|
|
|
This example includes the following tasks:
- Configure the Connector
- Modify the Main Template File
- Create the Sub Table Template File
- Start the Connector
NOTE: This example assumes that you have completed the steps in Extract Data from a Single Table and Extract Data from Multiple Tables.