How to fetch data from multiple index using join like sql

Elastic Stack Elasticsearch
3

thanks David, I read elastic doc for modeling data.I used like below:
I created one index(join_query_logic) for two table (Wallet_Location_Dim,User_Wallet_Location) and differentiate tables by using type(Wallet_Location_Dim,User_Wallet_Location).but when i am trying to get records using below query getting no records.

GET /join_query_logic/_search
{
"query": {
"bool": {
"must": [
{ "match": { "Wallet_Location_Dim.wallet_location_id": "User_Wallet_Location.wallet_location_id" }}
]
}
}
}