How to fetch data from multiple index using join like sql

Elastic Stack Elasticsearch
7

I just send you example which i followed.I want the records from join_sql_logic index for Wallet_Location_Dim index type where wallet location id from both type(Wallet_Location_Dim,User_Wallet_Location) should match.I showed you in post.