1:M query

[SandraDema]

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?

[JaiSiva1]

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