Bug
The Make Query Table geoprocessing tool does not generate a valid new key field (OID) in ArcGIS Pro 2.2 for a many-to-many join of a table to feature class, although the tool does in ArcMap 10.6.
| Bug ID Number | BUG-000118293 |
|---|---|
| Submitted | November 19, 2018 |
| Last Modified | June 25, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.2 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
- Open MakeQueryTable_bug.mpk in ArcMap 10.6.
- Run Make Query Table tool on the Iowa CountyBoundaries and IowaCountyTable with the following input parameters (MakeQueryTable_ArcMap.jpg):
- The tool runs successfully.
- Select by Attribute with the following input parameters(SelectByAttribute_ArcMap.jpg):
- Selection works as expected.
- Export the temporary query table to a feature class (right-click on the layer in the Table of Contents > Data > Export Data) in a file geodatabase.
- Open the attribute table and the fields display as expected (CorrectFields_ArcMap.jpg).
Steps to Reproduce
Bug ID: BUG-000118293
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App