Problem: Querying a spatial view in ArcGIS Desktop returns inconsistent results
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.