Fetch data with multiple indexes

OpenSearch
,
1

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:

2

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