PROBLEM

Definition queries and definition selection sets are ignored by joins in ArcMap

Last Published: April 25, 2020

Description

Definition queries and selection sets defined on the join layer are ignored by the join.

Cause

The table underlying the join layer is used to create a join. This table has no knowledge of settings made on the join layer.

Solution or Workaround



Re-create the definition query or the definition selection set after the join.

Note:
Spatial joins respect the definition queries and the definition selection of both the join and target layers.

Article ID: 000002969

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options