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
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?