Building a query with the Advanced SQL Calculator

An SQL expression can be defined to query features across a database or across multiple databases if you are not in an edit session. The results of the query are displayed in the Advanced SQL Calculator Results window.

SQL expressions are built according to a standard syntax. For more information, see Building a query expression.

1. Start ArcMap.
2. Load data in the map if necessary.
3. Click the Advanced SQL Calculator button on the Nautical toolbar.

   The Advanced SQL Calculator dialog box appears.

   

4. From the Choose Layers list, choose the list of layers for which you want to run the query.
5. If you only want to include features in the current extent, check the Only query current extent check box.
6. In the Fields list, choose the field you want to use in the query.
7. Click Get Unique Values if you want to display a list of values that exist in the database.

   The unique values for the field appear.

8. Construct an SQL query expression.

   Tip:

   Click Clear to delete a previously created expression and create a new one.

   For more information, see Building a query expression.

9. Click Verify to validate your query syntax.

   Note:

   SQL syntax can only be verified against a single layer.

10. If you want to display any additional fields in the feature classes, check the check boxes next to their names in the Choose additional display fields list.

    Tip:

    You can click Check all to display all available fields.

11. Click Apply.

The query results appear in the Advanced SQL Calculator Results window.