# Join two json in elastic search
**URL:** https://discuss.elastic.co/t/join-two-json-in-elastic-search/122460
**Category:** Elasticsearch
**Created:** [March 5, 2018, 8:34am UTC](https://discuss.elastic.co/t/join-two-json-in-elastic-search/122460 "2018-03-05T08:34:47Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Somok\_Sarkar\_IN](https://discuss.elastic.co/u/Somok_Sarkar_IN)
#### Post date: [March 5, 2018, 8:34am UTC](https://discuss.elastic.co/t/join-two-json-in-elastic-search/122460/1 "2018-03-05T08:34:48Z")
I have a specific requirement where two json files are in elastic and having a common attribute called "code\_type". Like in table we do inner join " where a.code\_type=b.code\_type" is there any way we can achieve that in elastic search and view data in Kibana?
We are using elastic from AWS service and the version present there is 6.0
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 5, 2018, 3:50pm UTC](https://discuss.elastic.co/t/join-two-json-in-elastic-search/122460/2 "2018-03-05T15:50:20Z")
You can't do joins in elasticsearch.
> We are using elastic from AWS service and the version present there is 6.0
Did you look at [cloud.elastic.co](http://cloud.elastic.co) or [AWS Marketplace: Elastic Cloud (Elasticsearch Service)](https://aws.amazon.com/marketplace/pp/B01N6YCISK) ?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 2, 2018, 3:51pm UTC](https://discuss.elastic.co/t/join-two-json-in-elastic-search/122460/3 "2018-04-02T15:51:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.