topic Re: Error when creating a query table in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881465#M6784 <HTML><HEAD></HEAD><BODY><P>Can you show the rest of your Make Query Table screen, e.g., the Key Field Options and Key Fields settings?&nbsp; Also, have you tried "ADD_VIRTUAL_KEY_FIELD" instead of "USE_KEY_FIELDS"?</P><P></P><P>Also, the documentation states "All input feature classes or tables must be from the same input <SPAN class="glossary">workspace</SPAN>."&nbsp; Are both your tables in the same input workspace?</P></BODY></HTML> Mon, 26 Oct 2015 14:47:38 GMT JoshuaBixby 2015-10-26T14:47:38Z Error when creating a query table https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881464#M6783 <HTML><HEAD></HEAD><BODY><P>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.</P><P>What might be the issue here?</P><P></P><P>Any help is appreciated,</P><P>Hani</P><P></P><P><IMG alt="Clip_36.jpg" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/133324_Clip_36.jpg" style="width: 620px; height: 389px;" /></P><P></P><P><IMG alt="Clip_37.jpg" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/133331_Clip_37.jpg" style="width: 620px; height: 507px;" /></P></BODY></HTML> Mon, 26 Oct 2015 13:04:51 GMT https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881464#M6783 HaniDraidi 2015-10-26T13:04:51Z Re: Error when creating a query table https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881465#M6784 <HTML><HEAD></HEAD><BODY><P>Can you show the rest of your Make Query Table screen, e.g., the Key Field Options and Key Fields settings?&nbsp; Also, have you tried "ADD_VIRTUAL_KEY_FIELD" instead of "USE_KEY_FIELDS"?</P><P></P><P>Also, the documentation states "All input feature classes or tables must be from the same input <SPAN class="glossary">workspace</SPAN>."&nbsp; Are both your tables in the same input workspace?</P></BODY></HTML> Mon, 26 Oct 2015 14:47:38 GMT https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881465#M6784 JoshuaBixby 2015-10-26T14:47:38Z Re: Error when creating a query table https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881466#M6785 <HTML><HEAD></HEAD><BODY><P>As I found in this thread: <A href="https://community.esri.com/message/562546">Make Query Table problem</A> </P><P></P><P>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...</P></BODY></HTML> Wed, 27 Jan 2016 15:13:09 GMT https://community.esri.com/t5/geodatabase-questions/error-when-creating-a-query-table/m-p/881466#M6785 HåvardMoe 2016-01-27T15:13:09Z