# ES|QL command join

**URL:** <https://discuss.elastic.co/t/es-ql-command-join/363425>\
**Category:** Kibana\
**Created:** [July 19, 2024, 11:15am UTC](https://discuss.elastic.co/t/es-ql-command-join/363425 "2024-07-19T11:15:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nspaniol](https://avatars.discourse-cdn.com/v4/letter/n/49beb7/32.png) [@nspaniol](https://discuss.elastic.co/u/nspaniol)\
**Post date:** [July 19, 2024, 11:15am UTC](https://discuss.elastic.co/t/es-ql-command-join/363425/1 "2024-07-19T11:15:28Z")

</div>

Hello Team,

I am new to the environment Kibana and used some commands for a few weeks.

My question today is about the ES|QL language. There are several types of commands, written down in the Docs.

Through my lecture, I haven’t found yet a command that would make possible the merge of two separate databases.

Is there a command, equivalent to JOIN in SQL, in Elastic Search ?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [July 19, 2024, 2:13pm UTC](https://discuss.elastic.co/t/es-ql-command-join/363425/2 "2024-07-19T14:13:26Z")

</div>

HI @nspaniol Welcome to the community.

Today, there is `enrich`

> **[ES|QL commands | Elasticsearch Guide \[8.14\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/esql-commands.html#esql-enrich)**

You need to do a little prep on the data that is the source of the enrichment.

Abritraty joins are not supported, and large-scale arbitrary joins are not on the near-term roadmap.

However, I expect that in the near future, additional capabilities will be available, such as `lookup`, which will allow enriching (joining) a large index with an arbitrary smaller index or file, etc... Stay tuned for that.

---

<div class="post-metadata">

**Author:** ![Jennie\_Soria](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jennie_soria/32/58895_2.png) [@Jennie\_Soria](https://discuss.elastic.co/u/Jennie_Soria)\
**Post date:** [May 1, 2025, 1:14pm UTC](https://discuss.elastic.co/t/es-ql-command-join/363425/3 "2025-05-01T13:14:35Z")

</div>

As of version 8.18, there is available in (technical preview) SQL-style JOIN: ES|QL’s [LOOKUP JOIN command](https://www.elastic.co/docs/reference/query-languages/esql/commands/processing-commands#esql-lookup-join)

See blog : [ES|QL Joins are here! Yes, Joins!](https://www.elastic.co/blog/esql-lookup-join-elasticsearch)