topic Re: Does definition query on a join table get applied before or after the join? in ArcMap Questions

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

Bud — Mon, 10 Jul 2023 15:07:03 GMT

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?

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

RobertBorchert — Mon, 10 Jul 2023 15:05:07 GMT

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

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

Bud — Mon, 10 Jul 2023 15:59:33 GMT

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.