Attribute Class Join Properties Dialog Box: General Tab
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.
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 in the Joins tab of 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 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.