How to fetch data from multiple index using join like sql

Yes but I already told you that you can't do joins in elasticsearch.
You can use parent/child feature but I'd not use it unless it's absolutely needed. But I already said that.

Again, if you need help about modelling please answer this.

May be explain the use case, share some sample documents and what a typical user would like to search for?

1 Like