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

Question

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?

Bud · Answer

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.

RobertBorchert · Answer

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