Is it possible to apply inner join condition(in sql) on elastic search documents

[ravikumar_kotta]

Hi,

I need to enhance the feature called inner join(in sql) over the elasticsearch documents... how to get the fields from both parent and child types using "has_child" or "top_children". can u please give me the best solution for this.......

thanks
Ravikumar Kotta.