# Is Self Inner Join Supported in ES?

**URL:** https://discuss.elastic.co/t/is-self-inner-join-supported-in-es/377906
**Category:** Elasticsearch
**Tags:** eql-elastic-query-language
**Created:** [May 7, 2025, 12:56pm UTC](https://discuss.elastic.co/t/is-self-inner-join-supported-in-es/377906 "2025-05-07T12:56:13Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sekarvicky73](https://avatars.discourse-cdn.com/v4/letter/s/8baadc/32.png) [@sekarvicky73](https://discuss.elastic.co/u/sekarvicky73)
#### Post date: [May 7, 2025, 12:56pm UTC](https://discuss.elastic.co/t/is-self-inner-join-supported-in-es/377906/1 "2025-05-07T12:56:13Z")

</div>

is possible to the below DB in query in Elasticsearch in SIngle query.

```auto
SELECT * 
FROM ADSMFolderDetails a 
INNER JOIN ADSMFolderDetails b 
  ON a.parent_path = b.path 
 AND a.perm = b.perm 
 AND a.sid = b.sid

```

---

<div class="post-metadata">

### Author: ![RainTown](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raintown/32/140206_2.png) [@RainTown](https://discuss.elastic.co/u/RainTown)
#### Post date: [May 8, 2025, 1:18pm UTC](https://discuss.elastic.co/t/is-self-inner-join-supported-in-es/377906/2 "2025-05-08T13:18:23Z")

</div>

Welcome to the forum !!

> [@sekarvicky73](#):
>
> is possible to the below DB in query in Elasticsearch in SIngle query.

Maybe, more likely not.

INNER JOIN do not translate that well, in part as elasticsearch is not really a "database" in same way as traditional "databases".

But close to impossible to say without knowing something about the data in ADSMFolderDetails, and how that is mapped to elasticsearch documents. Show us some sample data from ADSMFolderDetails, and how that is represented in Elasticsearch docs (usually a few json documents would suffice) and someone can maybe help, suggest other ideas to return same results as your SQL query.

---

<div class="post-metadata">

### Author: ![Carlos\_D](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_d/32/126245_2.png) [@Carlos\_D](https://discuss.elastic.co/u/Carlos_D)
#### Post date: [May 9, 2025, 1:36pm UTC](https://discuss.elastic.co/t/is-self-inner-join-supported-in-es/377906/3 "2025-05-09T13:36:40Z")

</div>

It's not possible to use JOINs using the Query DSL. But you can use them in ES|QL, the new query language for Elasticsearch.

Check this [blog post](https://www.elastic.co/blog/esql-lookup-join-elasticsearch) for more details.