I am using javascript and asp, and using ArcGIS Server services. I need to create a 1:M relationship and be able to query against the "many" table. For example:
For every house (a spatial feature), there can be multiple pets(a joined table from sql, with 0 to many entries per house).
Select * from join where pet = "dog".
I have found several ways to join the data, but none that I can query against. Any ideas?
As mentioned by Jayanta Poddar ,
You can query the REST Services using Query Related tables.
Ex: Query RelatedRecords Example
Query performed on the REST Service.
and the Relationship query can be performed in the js api using the "RelationshipQuery" class