# Can we perform joins on the Indexes in ES?
**URL:** https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122
**Category:** Kibana
**Created:** [May 1, 2018, 1:22pm UTC](https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122 "2018-05-01T13:22:54Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@manjur](https://discuss.elastic.co/u/manjur)
#### Post date: [May 1, 2018, 1:22pm UTC](https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122/1 "2018-05-01T13:22:54Z")
Hi,
I have shipped data from sql server to ES using logstash. I have created two indexes in Kibana,. I just want to join two documents to get required results.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 1, 2018, 2:18pm UTC](https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122/2 "2018-05-01T14:18:18Z")
Elasticsearch and Kibana does not support joins, so when working with relational data it is generally recommended to denormalise data into entities that match what you will be searching for before you ingest the data. If you can provide a bit more information about your data and how you want to query it, someone might be able to help come up with a solution.
---
### Author:  [@darkmoon](https://discuss.elastic.co/u/darkmoon)
#### Post date: [May 1, 2018, 3:02pm UTC](https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122/3 "2018-05-01T15:02:47Z")
Lack of joins/subqueries/sequential queries is the biggest flaw in Elastic. (Yes, they're expensive, but forcing users to work around that is annoying and even more expensive.)
@manjur - another option is to script some queries at the API. You can can than use the results of the first query to build the second (which is all a sub query is doing under the hood). This works pretty well if your data isn't something that de-normalizes well.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 29, 2018, 3:07pm UTC](https://discuss.elastic.co/t/can-we-perform-joins-on-the-indexes-in-es/130122/4 "2018-05-29T15:07:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.