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.
[STATE] IN (select DISTINCT [STATE_NAME] from keyfile)
Get help from ArcGIS experts
Download the Esri Support App