# Query multiple indexes

**URL:** https://discuss.elastic.co/t/query-multiple-indexes/358633
**Category:** Elasticsearch
**Created:** [May 2, 2024, 10:42am UTC](https://discuss.elastic.co/t/query-multiple-indexes/358633 "2024-05-02T10:42:17Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Monica\_Andhare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/monica_andhare/32/134074_2.png) [@Monica\_Andhare](https://discuss.elastic.co/u/Monica_Andhare)
#### Post date: [May 2, 2024, 10:42am UTC](https://discuss.elastic.co/t/query-multiple-indexes/358633/1 "2024-05-02T10:42:17Z")

</div>

As a beginner in ELK . I want ask how can I query on multiple indexes. I have below 2 indexes.

1)Product index  
-id  
-DisplayName

1. ProductAssociation index  
-id  
-SourceAssociationId  
-DestinationAssociationId

Product index sample data  
{  
{  
id:"101",  
DisplayName:"CLAMP-2"  
},  
{  
id:"201",  
DisplayName:"Avenger"  
},  
{  
id:"202",  
DisplayName:"Pulsar"  
}  
}

ProductAssociation index sample data  
{  
{  
id:"001",  
SourceAssociationId:"201",  
DestinationAssociationId:"101"  
},  
{  
id:"001",  
SourceAssociationId:"202",  
DestinationAssociationId:"101"  
}  
}

part CLAMP-2 has association with 201,202. I want to fetch below data by part name "CLAMP-2" which is product.DisplayName  
{  
{  
id:"201",  
DisplayName:"Avenger"  
},  
{  
id:"202",  
DisplayName:"Pulsar"  
}  
}

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 2, 2024, 10:53am UTC](https://discuss.elastic.co/t/query-multiple-indexes/358633/2 "2024-05-02T10:53:48Z")

</div>

That sounds a lot like a join between 2 indices, which Elasticsearch does not support. You either need to split this into 2 queries or restructure and denormalise your data in Elasticsearch.