Querying a spatial view in ArcGIS Desktop returns inconsistent results

Last Published: April 25, 2020


Selecting or displaying records in ArcMap or ArcCatalog from a spatial view with one-to-many cardinality returns inconsistent results.

Operations like Identify may only return the first related record, rather than all related records.


ArcGIS Desktop requires ObjectID values be unique per record. If a spatial view joins one record in the feature class to several records in another table (a one-to-many join), the ObjectID values are no longer unique per record. This is not supported in ArcGIS Desktop.

Solution or Workaround

Use a relationship class or a RELATE function to join the feature class with the associated attribute table in ArcGIS Desktop.

    Article ID:000010415

    • ArcMap

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic