# Essql join on canvas essql

**URL:** <https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [May 31, 2021, 12:11pm UTC](https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496 "2021-05-31T12:11:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lucac](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@lucac](https://discuss.elastic.co/u/lucac)\
**Post date:** [May 31, 2021, 12:11pm UTC](https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496/1 "2021-05-31T12:11:25Z")

</div>

Hi,  
is it possible to write an essql query with join inside?

I have a field in one index and I would to compare that to another field in another index and extract some value.

I need this value in canvas.

How can I do?

---

<div class="post-metadata">

**Author:** ![joshdover](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshdover/32/42020_2.png) [@joshdover](https://discuss.elastic.co/u/joshdover)\
**Post date:** [May 31, 2021, 1:14pm UTC](https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496/2 "2021-05-31T13:14:46Z")

</div>

Hi there!

Due to Elasticsearch's nature as a distributed document store, full joins across separate indices is not currently possible. You can read more about this limitation [here](https://www.elastic.co/guide/en/elasticsearch/reference/current/joining-queries.html).

We do have an alternative option which allows you to enrich new documents in one index with data from another index when the documents are ingested into Elasticsearch. For this option, see the [Enrich processor documentation](https://www.elastic.co/guide/en/elasticsearch/reference/current/enrich-setup.html).

---

<div class="post-metadata">

**Author:** ![lucac](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@lucac](https://discuss.elastic.co/u/lucac)\
**Post date:** [June 1, 2021, 7:29am UTC](https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496/3 "2021-06-01T07:29:30Z")

</div>

Can you give me an example of enrich policy?

How can I add one field from a index to another index?

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:** [June 29, 2021, 7:29am UTC](https://discuss.elastic.co/t/essql-join-on-canvas-essql/274496/4 "2021-06-29T07:29:57Z")

</div>

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