When creating a new join, will an existing INNER join on the join table be honored?
ArcGIS Pro 3.0.3; mobile geodatabase:
I've created an inner join from TABLE_A to TABLE_B using the Add Join GP tool -- by unchecking "Keep All Target Features":
Question:
Using a different table called TABLE_C, if I join to TABLE_A, will the inner join on TABLE_A be honored? In other words, will rows be omitted in the attribute table (aka values will be null) in TABLE_A due to the inner join?
Accepted Solutions
It looks like the answer is yes: The inner join on TABLE_A was honored in the new join.
Now that I've tested it, I suppose that behavior is expected. A regular join would be honored too.
Originally, I had thought that row 3 would be omitted entirely from the attribute table, similar to how a definition query on a join table works. But I realize now that was incorrect. Only the cells in TABLE_A and TABLE_B are omitted/null, not the entire row.
It looks like the answer is yes: The inner join on TABLE_A was honored in the new join.
Now that I've tested it, I suppose that behavior is expected. A regular join would be honored too.
Originally, I had thought that row 3 would be omitted entirely from the attribute table, similar to how a definition query on a join table works. But I realize now that was incorrect. Only the cells in TABLE_A and TABLE_B are omitted/null, not the entire row.
