# Parent child search (kind of like outer join)

**URL:** <https://discuss.elastic.co/t/parent-child-search-kind-of-like-outer-join/4471>\
**Category:** Elasticsearch\
**Created:** [May 25, 2011, 6:47am UTC](https://discuss.elastic.co/t/parent-child-search-kind-of-like-outer-join/4471 "2011-05-25T06:47:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![badcase](https://avatars.discourse-cdn.com/v4/letter/b/9fc29f/32.png) [@badcase](https://discuss.elastic.co/u/badcase)\
**Post date:** [May 25, 2011, 6:47am UTC](https://discuss.elastic.co/t/parent-child-search-kind-of-like-outer-join/4471/1 "2011-05-25T06:47:46Z")

</div>

Hi

As per release notes for 0.14, one of the features (for parent/child)  
that is being implemented is "returning the child docs as part of the  
search request".  
Any ideas when I should expect it to be there?

Currently I am trying to do a query on child table using "must" on  
parentId field and "should" on child fields wrapped in a bool query,  
but that does not return the parent, so have to do another query for  
that. Anybody know of a better way.

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:05am UTC](https://discuss.elastic.co/t/parent-child-search-kind-of-like-outer-join/4471/2 "2017-07-06T04:05:23Z")

</div>