How to fetch data from multiple index using join like sql

Last chance. Please read: