Hi there!
Due to Elasticsearch's nature as a distributed document store, full joins across separate indices is not currently possible. You can read more about this limitation here.
We do have an alternative option which allows you to enrich new documents in one index with data from another index when the documents are ingested into Elasticsearch. For this option, see the Enrich processor documentation.