---
title: "Basic Table Joins"
canonical: "https://kb.uconn.edu/space/DMRA/10883138186/Basic%20Table%20Joins"
format: markdown
---
InfoAssist users can join two or more related data sources (also referred to as tables) to create a larger pool of fields. The joined structure is a virtual way of accessing multiple data sources as if they were a single data source.

## Joining Tables 

1. Open an existing report or create a new report.
  1. If creating a new report, open the first table of data. The first table you select cannot be changed in a report.
2. Once the correct table is selected, click** Open**.
3. Click the **Data **tab, and then click **Join**.
4. In the **Join **dialog box, click **Add New. **
5. In the **Open** dialog box, select a second table.
6. Click **Open**. Notice the Join dialog box will display with two tables at this point.
7. Identify the common field of data in both tables. For example, EMPLID is the common field of data found in both tables used in the screenshots of this documentation.
8. Left-click the **field name** in the first table and hold to ensure the data remains selected.
9. Drag the selected data to the second table, releasing the left-click once the data from the first table is over the matching field name of data in the second table.
10. Notice the arrow between the two tables, indicating the join is successful. Left-click in the middle of the arrow to change the arrow's color to red.
11. Right-click in the middle of the red arrow to display a menu of options.
12. Click **Edit** from the list of available options.
13. From the **Edit Join **dialog box, confirm the selections from the **Instances** and** Type **dropdown menus are accurate for your Join.
14. Click **OK**.
15. To confirm your two tables have been joined, navigate to the **left data pane** from the main report view.
16. Click the **arrow **to expand the list of field names in the **first table.**
17. Scroll down to the bottom of the left data pane to locate the second table. Click the **arrow **to expand the list of field names in the **second table. **
18. To build the report, select the appropriate field(s) from either table, and drag the field(s) to the appropriate quadrant.

To add additional tables to this join, repeat the steps above at any point in the process.

> ℹ️ <span style="color: #333333">Refer to the vendor documentation </span>[WebFOCUS InfoAssist Manual 8.2.06](https://webfocusinfocenter.informationbuilders.com/WFDESIGNER/pdfs6/wfinfoasst.pdf)<span style="color: #333333"> for additional information.</span>

## Related Articles

> Macro (contentbylabel)

> Macro (details)
> 
> | Related issues |  |
> | --- | --- |