# 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:** 11

<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 6, 2019, 1:11pm UTC](https://discuss.elastic.co/t/how-can-we-convert-join-query-into-elastic-search/197783/11 "2019-09-06T13:11:53Z")

</div>

Hi @dadoonet.

Thanks

but looking for like below use case i think this is very simple for you to resolve my use case issue.

> [@Elastic-search advanced search query issue](https://discuss.elastic.co/t/elastic-search-advanced-search-query-issue/198254/3):
>
> Hi @dadoonet. Thanks i am trying to search the records based on below sql query condition -1 condition :- 01 i have 8-fields in current index use case and i want to search all fields value based on provided value with fields like- field1:'data' field2:'sata' field5:2424 field8:PHM Condition02:- in above search field i am not providing field value for field3,4,6,7 but we need this field for next search in current query and want exact matching result with previous - field1:'data' f…

Thanks  
HadoopHelp

---

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