# How can we convert join query into elastic search

**URL:** https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783
**Category:** Elasticsearch
**Created:** [September 3, 2019, 8:12am UTC](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783 "2019-09-03T08:12:15Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)
#### Post date: [September 5, 2019, 2:40pm UTC](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783/9 "2019-09-05T14:40:15Z")

</div>

Hi @dadoonet .

Thanks

but i don't have idea about implementation of parent\_child and nested query.

Note :- i have one more complex issue please review and please try to help?

> [@Elastic-search advanced search query issue](https://discuss.elastic.co/t/elastic-search-advanced-search-query-issue/198254):
>
> Dear All. I have some use case:- 01:- i have index(index01) that contains 8 fields :- fields like- a,b,c,d,e,f,g,h,i :- each fields has diff value 02:- now search condition here is? :- if i search for fields [a:"alpha"] then it will search all data matching with field[a] :- if search for fields [b:'data',c:'meta',d:'sata'] then it will search only fields[b,c,d] values but not other matched fields within [a,e,f,g,h] 03:- this is final case in, index fields[i] that contains integer v…

Thanks

---

_[View the full topic](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783)._