Error when creating a query table

2248
2
10-26-2015 06:04 AM
Highlighted
Occasional Contributor II

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

Clip_36.jpg

Clip_37.jpg

Reply
0 Kudos
2 Replies
Highlighted
MVP Esteemed Contributor

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?

Reply
0 Kudos
Highlighted
New Contributor III

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