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


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.......

Ravikumar Kotta.