The definition query in a table is not recognized when joining to a feature class if both table and feature class are stored in a Personal Geodatabase.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM006043
Submitted
January 11, 2007
Last Modified
April 28, 2025
Applies to
No Product Found
Version found
9.2
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Use the Make a Query Table tool to create a table in memory of the geodatabase table using the same query from the definition query. Then join the query table to the feature class.