5.2.2.1.2.2 Relations Area

The Relations area includes the following components:

• [Type]: Enables you to select the type of join (Inner, Left, and Right).
  • An Inner Join indicates that only those elements that are shared in both sources.
  • Left and Right are Outer Joins. An Outer Join indicates that you want the elements even if they are not (to the left or right) in both source datasets. (Not all databases currently support a Full Outer Join.) Text boxes to the right of the join type indicate the tables that a Join expression links together. The text box underneath the list specifies the Join condition.
• Delete: Deletes the selected Join relation expressions.
• Clear: Clears all Join relation expressions established for the Join of the datasets.
• Comment: Enables to add comments about the Join in this text area.