topic Definition Query through Relate in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/definition-query-through-relate/m-p/130952#M5647 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to create a Definition Query using the attributes from the related table in SDE??&nbsp; What I have is a point feature class WatermainBreaks with a 1:1 relationship to our Watermain layer.</P><P></P><P>I want to not show any WatermainBreak where the field "LININGINSTALLDATE" on the Watermain has a value (ie. Not Null).</P><P></P><P>Is this possible??&nbsp; I've tried everything I can think of in SQL mode, but nothing is working.</P></BODY></HTML> Wed, 04 Dec 2019 19:37:06 GMT BrianBulla 2019-12-04T19:37:06Z Definition Query through Relate https://community.esri.com/t5/arcgis-pro-questions/definition-query-through-relate/m-p/130952#M5647 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to create a Definition Query using the attributes from the related table in SDE??&nbsp; What I have is a point feature class WatermainBreaks with a 1:1 relationship to our Watermain layer.</P><P></P><P>I want to not show any WatermainBreak where the field "LININGINSTALLDATE" on the Watermain has a value (ie. Not Null).</P><P></P><P>Is this possible??&nbsp; I've tried everything I can think of in SQL mode, but nothing is working.</P></BODY></HTML> Wed, 04 Dec 2019 19:37:06 GMT https://community.esri.com/t5/arcgis-pro-questions/definition-query-through-relate/m-p/130952#M5647 BrianBulla 2019-12-04T19:37:06Z