# Join in es

**URL:** <https://discuss.elastic.co/t/join-in-es/84165>\
**Category:** Elasticsearch\
**Created:** [May 1, 2017, 4:23pm UTC](https://discuss.elastic.co/t/join-in-es/84165 "2017-05-01T16:23:35Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [May 1, 2017, 4:23pm UTC](https://discuss.elastic.co/t/join-in-es/84165/1 "2017-05-01T16:23:35Z")

</div>

i want to join two tables in elasticsearch like mysql? Can I help you? Please.........

---

<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:** [May 1, 2017, 4:59pm UTC](https://discuss.elastic.co/t/join-in-es/84165/2 "2017-05-01T16:59:36Z")

</div>

You can't

---

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [May 2, 2017, 1:03pm UTC](https://discuss.elastic.co/t/join-in-es/84165/3 "2017-05-02T13:03:23Z")

</div>

so do i can join in elasticsearch??

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [May 2, 2017, 1:15pm UTC](https://discuss.elastic.co/t/join-in-es/84165/4 "2017-05-02T13:15:15Z")

</div>

Elasticsearch does not support joins.

---

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [May 2, 2017, 1:16pm UTC](https://discuss.elastic.co/t/join-in-es/84165/5 "2017-05-02T13:16:28Z")

</div>

so i must do ???

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [May 2, 2017, 1:18pm UTC](https://discuss.elastic.co/t/join-in-es/84165/6 "2017-05-02T13:18:13Z")

</div>

A common approach is to denormalise data, but there are also features like parent-child and nested documents that can be used to model data. The correct technique does however depend on the use case, so it is very hard to give guidance without knowledge about your data and how you need to analyse/query it.

---

<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:** [May 30, 2017, 1:23pm UTC](https://discuss.elastic.co/t/join-in-es/84165/7 "2017-05-30T13:23:28Z")

</div>

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