Nested, join multiple indexes

You can not join across indices in Elasticsearch. You can represent some types of relationships using parent-child mappings or nested documents, but this requires data to be in a single index and is not a join. It is generally recommended to not try an think about your data in relational terms and instead denormalize data into a structure that suits how you want to search or aggregate it.