Select to view content in your preferred language

Does definition query on a join table get applied before or after the join?

433
2
05-29-2023 01:09 PM
Labels (1)
Bud
by
Honored Contributor

ArcMap 10.7.1; Oracle 18c EGDB:

I've joined from table A to B. The relationship is 1:M.
Note: Joins in ArcMap are one-to-first (i.e., the related record with the smallest OBJECTID wins, the rest are ignored). Whereas joins in ArcGIS Pro are one-to-many.

After the join is created, I apply a definition query to B.TYPE. 

Question:

Does the definition query get applied to table B before the join is applied, or after?

0 Kudos
2 Replies
RobertBorchert
Frequent Contributor III

do your join first then write the definition query.  The query will have specific names for the different fields based on the origin table.  

 

0 Kudos
Bud
by
Honored Contributor

As far as I can tell, ArcMap applies the join first, then the definition query. The definition query always gets applied last by ArcMap, regardless if it was created before the join was created.

0 Kudos