How to fetch data from multiple index using join like sql

{ "match": { "Wallet_Location_Dim.wallet_location_id": "User_Wallet_Location.wallet_location_id" }}

Is like joining documents. No you can't do that. May be explain the use case, share some sample documents and what a typical user would like to search for?