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.

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.
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