Open topic with navigation

# 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:

Table: Orders
OrderID
Date
CustomerID
Status
Table: Items
OrderID
ProductID
Quantity
Table: Products
ProductID
ProductName
Description
Price

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.

© 2018 EntIT Software LLC, a Micro Focus company | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm