I have one feature class and 3 tables which linked together by relationship classes.
The feature class, called "buildings", has the fellowing feilds: (1) FID: Feature ID and (2) ID: My own ID
This feature class is linked to a table, called "Partial", by one to one relationship. And it's linked to another table, called "Total", by one to one relationship, however, The table "Total" linked to onother table, called "Units", by one to many relationship.
How could I make a query that in all these tables/feature classes in ArcGIS 10.2?
What I've tried so far is the make query tool (image below), but It's not working well for me since the result was an empty table!
This is the database if anyone wants to give it a try