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,
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?
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...
Retrieving data ...