How to select related records in a definition query

Question

Good morning,

Is there a way to query the related records in a layer definition query in ArcGIS Pro or a Web Map. I some cases I want only so select records that have a specific value in a related field.

Thanks,

JohnGuilfoyle · Answer

The Select by Attributes tool allows you to query the database.
Select the dataset and view the Attributes Table.
Add a query Where:
*Field_Name*
(<, >, =, contains, ends with, begins with, contains the text, etc.)
Enter or select value

There is also a Select by Location tool that will find points near
polygons, etc.

TanuHoque · Answer

@SanchezNuñez

Adding a reference to another discussion on same/similar topic. I hope if this might help

https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-definition-query-to-select-a-group-of/m-p/1300418

Robert_LeClair · Answer

In ArcGIS Pro, you cannot directly query a related table in a Definition Query. Definition Queries are applied at the layer level and work with the attributes of the layer itself, not its related tables. With that said, I believe you can use the Make Query Table (Data Management)—ArcGIS Pro | Documentation geoprocessing tool to create the query layer and have it stored within your ArcGIS Pro project file.

Although this is an ArcMap resource page, here are some examples of making a query table - Examples of queries with the Make Query Table tool—ArcMap | Documentation