Use this dialog box to create a new join operation or to modify an existing join operation.
 Caution |
|---|
| Join operations are an advanced function of Microsoft SQL Server. Before configuring or modifying a join operation, you must have a good working knowledge of the Structured Query Language (SQL) syntax that is needed to create or modify various types of table joins. For more information about join operations, see your SQL Server documentation. |
The Attribute Class Join Properties tab includes the following fields:
Type
Selects the type of join to configure.
Inner
Displays only the matching results.
Left
Displays all the results for the base attribute and only the matching results for the join attribute.
Right
Displays all the results for the join attribute and only the matching results for the base attribute.
Full
Displays all the results for both the base attribute and the join attribute.
Join attribute
Select the attribute to be joined. This attribute will be connected to the base attribute on the Joins tab in the Query Statement Properties dialog box. The base attribute class is the attribute class that you have already added to the query to which you want to join another attribute class. The join attribute becomes a child of the selected attribute class in the tree. Click Select to select an attribute class and attribute.
Select
Click to open the Select Attribute dialog box, which enables you to select an attribute.
Operator
Select the relational operator that will be used in the join. The default operator is "is equal to."
Base attribute
Displays the base attribute class, optional alias, and attribute for the join operation. The attribute class selected in Join attribute, defined earlier, will be joined to this attribute class. You cannot change the base attribute class; however, you can click Select to change the base attribute.
Select
Click to open the Select Attribute dialog box, which you can use to select a different base attribute. The attribute class and optional alias are unavailable (they appear dimmed in the dialog box); you cannot change these.