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

_FT_HTML5_bannerTitle.htm