Creating Join Tables from Data Sources
A join table combines all the fields from two or more data sources in which the specified fields contain identical values.
You can use three different types of data sources in a Join statement:
- Lists
- Supplemental Data
- Profile Extensions
When you click the checkbox next to the first table to be joined, that table name is displayed at the top of the page. As you continue to select tables, their names are added to the selection list, in order.
To remove a table from the selection list, uncheck it.
Note: Spaces in table names cause problems when you’re joining tables. Use only tables that don't contain spaces in their names.
Tip: To update the data source later, click 
next to its name in the Folders list, and choose Change Join Conditions from the pop-up menu.