The Advanced Query Builder tool make it possible for you build complex queries without knowing how to write SQL statements. First you select the layer you want to query, and then you select the records or fields that you wish to query as well as the operator and the value. You can also add multiple conditions to the query. When you run the query, the results display in the Results List like all other searches.
To build a query using the Advanced Query Builder:
On the Maps & Data Sources tab of the toolbar, click Advanced Query.
The Advanced Query Builder opens in the information pane.
From the Query Layer drop-down list, select the layer that you want to query.
From the Operator drop-down list, select the operator, for example, Starts with.
In the Value field, type in the value you want to query, for example "Smi".
As you type, a list of possible options for this value displays.
The results of the query display in the Results List.