Attribute Class Join Properties: General Tab

Aplica-se a: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

Use this dialog box to create a new join operation or to modify an existing join operation.

CautionAtenção
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.

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.

Conteúdo da Comunidade

Mostrar: