Use this tab to combine attributes from two different attribute
classes with a join operation. For more information about
configuring join operations, see About Configuring
Attribute Class Joins.
Note |
Join operations are configured automatically on both the
General tab and the Criteria tab when you add attributes from more
than one attribute class to the query. In this case, you can use
the Joins tab to modify the properties of the join. |
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 various types of table joins.
For more information about join operations, see your SQL Server
documentation. |
- Attribute class joins
- Displays the attributes and attribute classes that are part of
the query and indicates whether they are joined. You can use this
table to combine attribute classes by creating a new join operation
or by modifying the attributes of an existing join operation.
- New button
- Click to open the Attribute Class Join Properties dialog box,
which you can use to join a new attribute class to the selected
attribute class. The selected attribute class is the base attribute
class. The base attribute class is an attribute class, which you
have already added to the query, to which you want to join another
attribute class. The new class that is joined becomes a child of
the selected attribute class in the tree.
- Modify button
- Click to open the Attribute Class Join Properties dialog box,
which you can use to modify the join properties of a selected
attribute class. The child attribute class must be selected.
- Delete button
- Click to remove a selected attribute class and all of its
subclasses from the query criteria. If the selected class or any of
its subclasses are used by any result attributes of the query
criteria, you will be prompted to confirm whether you want the
result attributes or criteria to be deleted from the query.
- Show Query Language
- Opens the Query Statements dialog box to display the query in
the Query Language view. You can work in the Query Language view to
compose or edit a query manually by using WBEM Query Language (WQL)
commands.
See Also