ODBC Connector 24.2

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

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL ODBC Connector 24.2

Topic Title: Extract Data from Multiple Tables using a JOIN