# Update using "join" with other index

**URL:** <https://discuss.elastic.co/t/update-using-join-with-other-index/217010>\
**Category:** Elasticsearch\
**Created:** [January 29, 2020, 1:30pm UTC](https://discuss.elastic.co/t/update-using-join-with-other-index/217010 "2020-01-29T13:30:17Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![inhinyera16](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/inhinyera16/32/61625_2.png) [@inhinyera16](https://discuss.elastic.co/u/inhinyera16)\
**Post date:** [January 29, 2020, 2:09pm UTC](https://discuss.elastic.co/t/update-using-join-with-other-index/217010/2 "2020-01-29T14:09:09Z")

</div>

Unfortunately can't do joins in elasticsearch. You need to reindex the data with parent/child relationship. Or you can read this related topic.

> [@How to fetch data from multiple index using join like sql](https://discuss.elastic.co/t/how-to-fetch-data-from-multiple-index-using-join-like-sql/106131/5):
>
> Hi David, I prefer this example of normalization. PUT /my\_index/user/1 { "name": "John Smith", "email": "john@smith.com", "dob": "1970/10/24" } PUT /my\_index/blogpost/2 { "title": "Relationships", "body": "It's complicated...", "user": { "id": 1, "name": "John Smith" } } for fetching records used: GET /my\_index/blogpost/\_search { "query": { "bool": { "must": [ { "match": { "title": "relationships" }}, { "…

---

_[View the full topic](https://discuss.elastic.co/t/update-using-join-with-other-index/217010)._