# Fetch data with multiple indexes

**URL:** <https://forum.opensearch.org/t/fetch-data-with-multiple-indexes/14933>\
**Category:** OpenSearch\
**Tags:** troubleshoot, index-management\
**Created:** [July 3, 2023, 8:58am UTC](https://forum.opensearch.org/t/fetch-data-with-multiple-indexes/14933 "2023-07-03T08:58:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SG2310](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@SG2310](https://forum.opensearch.org/u/SG2310)\
**Post date:** [July 3, 2023, 8:58am UTC](https://forum.opensearch.org/t/fetch-data-with-multiple-indexes/14933/1 "2023-07-03T08:58:45Z")

</div>

**Versions** (relevant - OpenSearch/Dashboard/Server OS/Browser):  
Open Search 2.5

**Describe the issue** :

I want to fetch data from multiple indexes and implement the condition on both indexes.

structure of both data is different.

can we join two indexes on any condition

**Configuration** :

**Relevant Logs or Screenshots** :

---

<div class="post-metadata">

**Author:** ![pablo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/pablo/32/10363_2.png) [@pablo](https://forum.opensearch.org/u/pablo)\
**Post date:** [July 3, 2023, 7:21pm UTC](https://forum.opensearch.org/t/fetch-data-with-multiple-indexes/14933/2 "2023-07-03T19:21:52Z")

</div>

@SG2310 You could try SQL join query but it requires a common field in both indices.

> **[Complex Queries](https://opensearch.org/docs/latest/search-plugins/sql/sql/complex/)**
>
> Complex queries