Query for documents presented in different index or type too

Have a look at parent/child and nested documents. There aren't other
join-like features. Usually the recommendation is to denormalize the data.