AnsweredAssumed Answered

Is there a way to use SQL Join in QueryTask Where clause?

Question asked by abjones on Jun 19, 2017
Latest reply on Jun 19, 2017 by TSolow-esristaff

I have a feature layer depicting many locations of wildlife collection efforts.   I have a table of species codes observed for each effort.  I have a table of characteristic codes assigned to each species code.  Each effort can identify many different critters.  Each critter has been assigned several codes from a list of characteristics. Using https://js.arcgis.com/3.20/ . If ArcGIS used standard SQL, I would be able to use Join in my Where clause to query and select effort features based on species code and/or characteristic codes; but in reading the documentation for QueryTask Where, it seems JOIN is not supported.  Have I misunderstood?  What is the best practice method, using ArcGIS JavaScript API, to query using SQL Join to a feature attribute?

Outcomes