SQL expressions fail for the Make Feature Layer tool when a join is present.
Last Published: April 19, 2017ArcGIS for Desktop
Bug ID Number
NIM066754
Submitted
March 31, 2011
Last Modified
June 5, 2024
Applies to
ArcGIS for Desktop
Version found
10.0
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
This issue is not reproducible in ArcGIS 10.4.1.
Workaround
- Use the Select by Attributes tool before running the Make Feature Layer tool.
- Create a definition query after the join, but before running the Make Feature Layer tool.
-----
Let Feature Class A = The feature class to which the table is joined.
Let Table B = The feature class which is joined to Feature Class A.
1. Establish which joined field (Field B) from Table B forms the basis for the query within the Make Feature Layer tool.
2. Before the join, create a field (Field A) in Feature Class A which is the equivalent to the desired field from Table B.
3. Join Table B to Feature Class A.
4. Set Field A = Field B.
5. Open the Make Feature Layer tool and create the SQL query based on Field A instead of Field B.