Pull data from multiple topic tables into a single table by creating a join.
Optionally, create joins for the subscription. To create a join, perform the following actions:
Select the topic tables to join from the
Select Left Table
and
Select Right Table
lists.
Select the join type from the
Select Join Type
list and then enter the join name in the
Join Name
field. The name that you assign to the join shows in the
Field Mapping
page, where you can map the join to a target table. The new join appears on the
Join
page.
Select the column to join from the left table and then select the column to join from the right table. To add more columns to the join click the plus sign and then select the columns to join.
Click
Create Join
.
Repeat step
1 to create as many joins as required.