# Query data from multiple indexes
**URL:** https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060
**Category:** Elasticsearch
**Created:** [November 9, 2018, 1:54pm UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060 "2018-11-09T13:54:27Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@balumurari1](https://discuss.elastic.co/u/balumurari1)
#### Post date: [November 9, 2018, 1:54pm UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/1 "2018-11-09T13:54:27Z")
Hello,
Can anyone help me that is there any possibility to query from multiple indexes,
For Example,
a. i have "index\_Students" with group of students data(id,name,state,city) in it.
b. i have "index\_StudentMarks" with marks of students(id,Subject1,Subject2,Subject3).
Now my question is how can i query data to get list of student marks from particular state?
Waiting for your response.
Thanks in advance
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [November 9, 2018, 1:57pm UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/2 "2018-11-09T13:57:46Z")
Elasticsearch does not support joins, so I would recommend you denormalise your data and store student data together with the marks.
---
### Author:  [@balumurari1](https://discuss.elastic.co/u/balumurari1)
#### Post date: [November 9, 2018, 2:00pm UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/3 "2018-11-09T14:00:19Z")
thanks @Christian_Dahlqvist for the reply,
Please correct me if i am wrong,
so do i need to create a new index like "index\_StudentmarksByCity" and load the data from logstash with the help of join query.
Waiting for your response
Thanks in advance.
---
### Author:  [@Jaspreet\_Singh](https://discuss.elastic.co/u/Jaspreet_Singh)
#### Post date: [November 12, 2018, 6:12pm UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/4 "2018-11-12T18:12:40Z")
Well you need a single index that stores students like this ...
```auto
{
"name": "John Doe",
"City":"Twiddle Dee",
"State":"Twiddle Dum",
"Marks": {
"Subject1": 97,
"Subject2": 57,
"Subject1": 98
}
}
```
Then you can query the single index.
---
### Author:  [@balumurari1](https://discuss.elastic.co/u/balumurari1)
#### Post date: [November 16, 2018, 11:36am UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/5 "2018-11-16T11:36:53Z")
thank you @Jaspreet_Singh & @Christian_Dahlqvist i have created new index as informed
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 14, 2018, 11:36am UTC](https://discuss.elastic.co/t/query-data-from-multiple-indexes/156060/6 "2018-12-14T11:36:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.