Fetch data with multiple indexes

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


Relevant Logs or Screenshots:

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