HOW TO
Perform a keyfile selection in ArcMap
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
Download the Esri Support App
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback