topic Make Query Table - help please with SQL! in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/make-query-table-help-please-with-sql/m-p/196367#M6722 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I'm having a bit of a play with the new temporal data support, and am trying to do a one-to-many join using Make Query Table so that I can visualise rainfall readings against weather station locations. </SPAN><BR /><BR /><SPAN>I have a File Geodatabase with a feature class "Rain_Gauges" and a table "Rainfall". </SPAN><BR /><BR /><SPAN>"Rain_Gauges" is a point feature class with fields "Object_ID", "Shape" and "Station_ID", contains 30 points numbered 1-30.</SPAN><BR /><BR /><SPAN>"Rainfall" is a table in the GDB with fields "Object_ID", "Station_ID", "Date_" and "Rainfall", contains numerous rainfall readings from each station over the period of 12 months.</SPAN><BR /><BR /><SPAN>"Station_ID" in both tables provides the common value to make the join.</SPAN><BR /><BR /><SPAN>Using Make Query Table from ArcToolbox, it all looks fairly straightforward and have been following the help instructions. The problem seems to be with the SQL expression to define the join.</SPAN><BR /><BR /><SPAN>Clicking the SQL button to get to Query Builder, am selecting the two fields to create the expression:</SPAN><BR /><BR /><SPAN>Rain_Gauges.Station_ID = Rainfall.Station_ID</SPAN><BR /><BR /><SPAN>Then defining Key_field as Rainfall.ObjectID and running the tool</SPAN><BR /><BR /><SPAN>Getting the error message:-</SPAN><BR /><BR /><SPAN>Error 999999: Error Executing Function</SPAN><BR /><SPAN>An invalid SQL statement was used [QueryTable]</SPAN><BR /><BR /><SPAN>Could someone please offer some guidance as to the correct SQL syntax to make this work? </SPAN><BR /><BR /><SPAN>Sorry if this seems a simple question, have not used Make Query Table before. </SPAN><BR /><BR /><SPAN>Rob</SPAN></BODY></HTML> Fri, 21 Jan 2011 10:23:34 GMT RobertKnight 2011-01-21T10:23:34Z Make Query Table - help please with SQL! https://community.esri.com/t5/geoprocessing-questions/make-query-table-help-please-with-sql/m-p/196367#M6722 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>I'm having a bit of a play with the new temporal data support, and am trying to do a one-to-many join using Make Query Table so that I can visualise rainfall readings against weather station locations. </SPAN><BR /><BR /><SPAN>I have a File Geodatabase with a feature class "Rain_Gauges" and a table "Rainfall". </SPAN><BR /><BR /><SPAN>"Rain_Gauges" is a point feature class with fields "Object_ID", "Shape" and "Station_ID", contains 30 points numbered 1-30.</SPAN><BR /><BR /><SPAN>"Rainfall" is a table in the GDB with fields "Object_ID", "Station_ID", "Date_" and "Rainfall", contains numerous rainfall readings from each station over the period of 12 months.</SPAN><BR /><BR /><SPAN>"Station_ID" in both tables provides the common value to make the join.</SPAN><BR /><BR /><SPAN>Using Make Query Table from ArcToolbox, it all looks fairly straightforward and have been following the help instructions. The problem seems to be with the SQL expression to define the join.</SPAN><BR /><BR /><SPAN>Clicking the SQL button to get to Query Builder, am selecting the two fields to create the expression:</SPAN><BR /><BR /><SPAN>Rain_Gauges.Station_ID = Rainfall.Station_ID</SPAN><BR /><BR /><SPAN>Then defining Key_field as Rainfall.ObjectID and running the tool</SPAN><BR /><BR /><SPAN>Getting the error message:-</SPAN><BR /><BR /><SPAN>Error 999999: Error Executing Function</SPAN><BR /><SPAN>An invalid SQL statement was used [QueryTable]</SPAN><BR /><BR /><SPAN>Could someone please offer some guidance as to the correct SQL syntax to make this work? </SPAN><BR /><BR /><SPAN>Sorry if this seems a simple question, have not used Make Query Table before. </SPAN><BR /><BR /><SPAN>Rob</SPAN></BODY></HTML> Fri, 21 Jan 2011 10:23:34 GMT https://community.esri.com/t5/geoprocessing-questions/make-query-table-help-please-with-sql/m-p/196367#M6722 RobertKnight 2011-01-21T10:23:34Z Answered my own question! https://community.esri.com/t5/geoprocessing-questions/make-query-table-help-please-with-sql/m-p/196368#M6723 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi<BR /><BR />I'm having a bit of a play with the new temporal data support, and am trying to do a one-to-many join using Make Query Table so that I can visualise rainfall readings against weather station locations. <BR /><BR />I have a File Geodatabase with a feature class "Rain_Gauges" and a table "Rainfall". <BR /><BR />"Rain_Gauges" is a point feature class with fields "Object_ID", "Shape" and "Station_ID", contains 30 points numbered 1-30.<BR /><BR />"Rainfall" is a table in the GDB with fields "Object_ID", "Station_ID", "Date_" and "Rainfall", contains numerous rainfall readings from each station over the period of 12 months.<BR /><BR />"Station_ID" in both tables provides the common value to make the join.<BR /><BR />Using Make Query Table from ArcToolbox, it all looks fairly straightforward and have been following the help instructions. The problem seems to be with the SQL expression to define the join.<BR /><BR />Clicking the SQL button to get to Query Builder, am selecting the two fields to create the expression:<BR /><BR />Rain_Gauges.Station_ID = Rainfall.Station_ID<BR /><BR />Then defining Key_field as Rainfall.ObjectID and running the tool<BR /><BR />Getting the error message:-<BR /><BR />Error 999999: Error Executing Function<BR />An invalid SQL statement was used [QueryTable]<BR /><BR />Could someone please offer some guidance as to the correct SQL syntax to make this work? <BR /><BR />Sorry if this seems a simple question, have not used Make Query Table before. <BR /><BR />Rob</BLOCKQUOTE><BR /><BR /><BR /><SPAN>If it's any help to anyone else, I noticed that the Station_ID fields were of a different type in the feature class compared with the table. Making them both Integer field did the trick.</SPAN></BODY></HTML> Fri, 21 Jan 2011 11:59:46 GMT https://community.esri.com/t5/geoprocessing-questions/make-query-table-help-please-with-sql/m-p/196368#M6723 RobertKnight 2011-01-21T11:59:46Z