# Join queries between indices

**URL:** <https://discuss.elastic.co/t/join-queries-between-indices/135828>\
**Category:** Elasticsearch\
**Created:** [June 14, 2018, 4:56am UTC](https://discuss.elastic.co/t/join-queries-between-indices/135828 "2018-06-14T04:56:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akib\_Ali](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Akib\_Ali](https://discuss.elastic.co/u/Akib_Ali)\
**Post date:** [June 14, 2018, 4:56am UTC](https://discuss.elastic.co/t/join-queries-between-indices/135828/1 "2018-06-14T04:56:51Z")

</div>

We are indexing some entities in elasticsearch indices which have relationships with each other. Can we perform query which will perform some joins between indices and returns the results in single call.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 14, 2018, 5:34am UTC](https://discuss.elastic.co/t/join-queries-between-indices/135828/2 "2018-06-14T05:34:25Z")

</div>

Only with parent child feature but joins in general are not supported.

It's always better to denormalize your data and do the needed joins at index time.

---

<div class="post-metadata">

**Author:** ![Akib\_Ali](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Akib\_Ali](https://discuss.elastic.co/u/Akib_Ali)\
**Post date:** [June 14, 2018, 8:49am UTC](https://discuss.elastic.co/t/join-queries-between-indices/135828/3 "2018-06-14T08:49:13Z")

</div>

ok so basically we can not have any such queries.Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 12, 2018, 8:49am UTC](https://discuss.elastic.co/t/join-queries-between-indices/135828/4 "2018-07-12T08:49:20Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
