Is it possible to create a Definition Query using the attributes from the related table in SDE?? What I have is a point feature class WatermainBreaks with a 1:1 relationship to our Watermain layer.
I want to not show any WatermainBreak where the field "LININGINSTALLDATE" on the Watermain has a value (ie. Not Null).
Is this possible?? I've tried everything I can think of in SQL mode, but nothing is working.