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. On the main menu, click Customize > Toolbars > Production Editing.
4. Add the Advanced SQL Calculator tool by doing the following:
   1. Click Customize > Customize Mode on the main menu.

      The Customize dialog box appears.

   2. Click the Commands tab.
   3. In the Categories list, click Production Editing.
   4. Click and drag the Advanced SQL Calculator button to a toolbar.
   5. Click Close.
5. Click the Advanced SQL Calculator button .

   The Advanced SQL Calculator dialog box appears.

   

6. From the Choose Layers list, choose the list of layers for which you want to run the query.
7. If you only want to include features in the current extent, check the Only query current extent check box.
8. In the Fields list, choose the field you want to use in the query.
9. 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.

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

11. Click Verify to validate your query syntax.

    Note:

    SQL syntax can only be verified against a single layer.

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

13. Click Apply.

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