Query Statement Properties Dialog Box: Joins Tab

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

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

Picture of Properties 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.

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

Other tabs in this dialog box: General, Criteria

Related Topics

Topic Link

About Attribute Class Joins

Topic Link

About Queries

Topic Link

About Query Elements

Topic Link

Using Queries to Locate Resources Overview