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.
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.
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.
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 Query Language view. You can work
in Query Language view to compose or edit a query manually using
WBEM Query Language (WQL) commands.