ArcGIS Pro 3.1.1; file geodatabase
I have a table in a FGDB called TEST_TABLE. I've copy/pasted the table via Catalog into the same FGDB as TEST_TABLE_2.
I've added both tables to the map. In the attribute table of TEST_TABLE, I create a join to TEST_TABLE_2 via the OBJECTID columns.
With TEST_TABLE, I open Contents —> right-click —> Properties —> Joins. The join is shown as one-to-many. But it's actually a one-to-one join -- because the tables being exact copies and the fact that OBJECTIDs don't allow duplicate IDs.
Why is the join shown as one-to-many if it is one-to-one?
Video:
Note:
I used the simple case above to demonstrate the issue. But my real use case is creating a database view on TEST_TABLE and joining from TEST_TABLE to the view.
select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table
The same issue happens with the joined view: the join is shown as one-to-many but it is actually one-to-one.
See Virtual Attributes (ad hoc), Promote selected records, or Specify how nulls are sorted for background info.
