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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic