Definition Query Based on Related Table

1327
3
12-06-2010 10:15 AM
Status: Open
BrandonJones
New Contributor II
It would be nice if I could perform a definition query based on fields in a related table in a 1:M or M:M relationship.
3 Comments
ChristiNelson1
has this been enabled yet? 
ChrisFox
You can do this now without a relationship class, but it requires both features classes be in the same geodatabase. Below is an example query:

"STATE_NAME" IN (SELECT "NAME" FROM states WHERE "POP1990" > 1000000)
 
In the query above I am selecting the Cities by the State they are related to whose State's population is greater than 10 million. Below is the format of the query explained

"{Primary Key Name}" IN (SELECT "{Foriegn Key Name}" FROM {Destination Table/FC Name} WHERE {WHERE clause to be run for related table})
BenjaminKnott2
The Definition Query fields from a joined table are available.  Why not a related table?