HOW TO

Perform a keyfile selection in ArcMap

Last Published: April 25, 2020

Summary

In ArcInfo Workstation, the RESELECT and ASELECT commands have a KEYFILE option. This allows features or records to be selected based on a separate look up table having matching values in a specified item.

This article provides an example of the syntax to perform a keyfile selection in ArcMap.

Procedure

In the Select By Attributes dialog, use SQL syntax such as the following:

Code:
[STATE] IN (select DISTINCT [STATE_NAME] from keyfile)


The sub query is first executed and returns a unique list of STATE_NAME values from the KEYFILE table. Features or records are then selected if matching values are found in the STATE column.

    Article ID:000007492

    Software:
    • ArcMap 9 x
    • ArcMap 8 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic