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
- Custom tables
- 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.
Good to know
- Filters, SQL statements, and joins don’t appear in the list on this page. To use such a data source in this join, you must first make a copy of it, then select that copy from the list on this page.
- Spaces in table names cause problems when you’re joining tables. Use only tables that don't contain spaces in their names.
- 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. - For custom tables, you can have multiple levels of joins, up to three levels deep. This enables you to construct more useful data models. For example, you can create a data model that links a customer's profile to their orders, their orders to each order's line items, and each order line item to details of the item in a product catalog.