When creating a join between two tables in a pgdb and keeping all records, the unmatched records are lost in 9.1 SP 2.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM004105
Submitted
September 6, 2006
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.1
Status
Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Add XY data from the table to make a feature class. The join can then be created between a feature class and a table through the layer's context menu or the Add Join GP tool (not through the joins and relates tab-NIM003593).Convert the PGDB tables to DBF tables, then perform the Join.