# Join implementation for multiple master data

**URL:** <https://discuss.elastic.co/t/join-implementation-for-multiple-master-data/117596>\
**Category:** Elasticsearch\
**Created:** [January 30, 2018, 10:02am UTC](https://discuss.elastic.co/t/join-implementation-for-multiple-master-data/117596 "2018-01-30T10:02:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sivaprakash\_Shanmuga](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@Sivaprakash\_Shanmuga](https://discuss.elastic.co/u/Sivaprakash_Shanmuga)\
**Post date:** [January 30, 2018, 10:02am UTC](https://discuss.elastic.co/t/join-implementation-for-multiple-master-data/117596/1 "2018-01-30T10:02:41Z")

</div>

Hi

Here is my MySQL database design

Table 1 (Foregion Key refernce)

- userId
- deviceId
- groupId

All these fields are referred from other table where I kept User, Device, Group - names and other info. Im trying to move that data into Elastisearch and perform search. As per ES 6.0 we need to keep reference data in same Index.

- Can I keep more than references in same document
- When I search and retrieve I would like to get Details of User, Device, Group like name, status etc.

Any reference?

---

<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:** [February 27, 2018, 10:03am UTC](https://discuss.elastic.co/t/join-implementation-for-multiple-master-data/117596/2 "2018-02-27T10:03:22Z")

</div>

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