# SQL for parent-child relationships

**URL:** https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963
**Category:** Elasticsearch
**Tags:** elastic-stack-sql
**Created:** [November 21, 2019, 6:59pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963 "2019-11-21T18:59:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Balu\_P](https://avatars.discourse-cdn.com/v4/letter/b/3ec8ea/32.png) [@Balu\_P](https://discuss.elastic.co/u/Balu_P)
#### Post date: [November 21, 2019, 6:59pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963/1 "2019-11-21T18:59:28Z")

</div>

Can I use elastic SQL for quering parent-child relationships

---

<div class="post-metadata">

### Author: ![Julien](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/julien/32/19688_2.png) [@Julien](https://discuss.elastic.co/u/Julien)
#### Post date: [November 21, 2019, 9:14pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963/2 "2019-11-21T21:14:04Z")

</div>

Unfortunately no there is no support for parent-child per [https://github.com/elastic/elasticsearch/issues/29828](https://github.com/elastic/elasticsearch/issues/29828)

---

<div class="post-metadata">

### Author: ![Balu\_P](https://avatars.discourse-cdn.com/v4/letter/b/3ec8ea/32.png) [@Balu\_P](https://discuss.elastic.co/u/Balu_P)
#### Post date: [November 21, 2019, 9:16pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963/3 "2019-11-21T21:16:00Z")

</div>

THank you

---

<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 19, 2019, 9:16pm UTC](https://discuss.elastic.co/t/sql-for-parent-child-relationships/208963/4 "2019-12-19T21:16:03Z")

</div>

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