# Child query

**URL:** <https://discuss.elastic.co/t/child-query/107237>\
**Category:** Elasticsearch\
**Created:** [November 10, 2017, 8:35pm UTC](https://discuss.elastic.co/t/child-query/107237 "2017-11-10T20:35:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lennycampino](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lennycampino/32/24084_2.png) [@lennycampino](https://discuss.elastic.co/u/lennycampino)\
**Post date:** [November 10, 2017, 8:35pm UTC](https://discuss.elastic.co/t/child-query/107237/1 "2017-11-10T20:35:48Z")

</div>

Hello,  
[https://imgur.com/a/9kx4g](https://imgur.com/a/9kx4g)  
that is my data model. Each user has multiple childs with another user id.... I want to return all users except those who are listed in a child of that user.... Could you please help me how i can filter / query this problem?

 ![17](https://us1.discourse-cdn.com/elastic/original/3X/5/f/5fbd8f29f2266d88d804d79464cc3cd8ce797a6a.png)

Its like this in SQL:  
SELECT a FROM table1 WHERE a NOT IN (SELECT a FROM table2)

---

<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:** [December 8, 2017, 8:36pm UTC](https://discuss.elastic.co/t/child-query/107237/2 "2017-12-08T20:36:19Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.