I am trying to create a query table that joins two tables based on a common key field in the two tables (Parcel_ID). However, when I run this tool, it ends with the error below.
What might be the issue here?
Any help is appreciated,
Hani
As I found in this thread: Make Query Table problem
The issue seems to be with the quotation marks in the SQL statement. I had the same problem as you, and it resolved once I removed the quotation marks...
Can you show the rest of your Make Query Table screen, e.g., the Key Field Options and Key Fields settings? Also, have you tried "ADD_VIRTUAL_KEY_FIELD" instead of "USE_KEY_FIELDS"?
Also, the documentation states "All input feature classes or tables must be from the same input workspace." Are both your tables in the same input workspace?
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
