AnsweredAssumed Answered

How to use a Query that References Two Tables of a Map Service

Question asked by william.miller_WarrenCoGIS on Feb 8, 2017
Latest reply on Feb 8, 2017 by rscheitlin

Hi,

I need to query two tables from a map service. Below is how the SQL statement I would like to use might look.

var queryString = "";
//from URL_For/MapServer/2
queryString += "Neighborhood_ID = '" + this.m_Neighborhood + "'";
queryString += " AND Use_Code_Dsc = '" + this.m_UseCodeOne + "'";
//from URL_For/MapServer/1
queryString += " AND convey_date = " + this._formatSqlDate(this.m_SaleDateSingle);
queryString += " AND consideration " + this.m_SalePriceOperatorDisplay + " " + this.m_SalePriceSingle;
query.where = queryString

How would I use QueryTask? I have two URLs. Is there a way to join the tables and then perform the QueryTask?

Thank you for your time.

William

Outcomes