# Merge data on field bases
**URL:** https://discuss.elastic.co/t/merge-data-on-field-bases/274745
**Category:** Elasticsearch
**Created:** [June 2, 2021, 12:02pm UTC](https://discuss.elastic.co/t/merge-data-on-field-bases/274745 "2021-06-02T12:02:41Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Abdoul\_Kande](https://discuss.elastic.co/u/Abdoul_Kande)
#### Post date: [June 2, 2021, 12:02pm UTC](https://discuss.elastic.co/t/merge-data-on-field-bases/274745/1 "2021-06-02T12:02:41Z")
Hello,
I would like to do the join of two indexes based on an id column.
can i have an example ?
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [June 2, 2021, 12:12pm UTC](https://discuss.elastic.co/t/merge-data-on-field-bases/274745/2 "2021-06-02T12:12:25Z")
Elasticsearch does unfortunately not support query time joins. If this is a query you will need to run frequently you may need to find a workaround, e.g. by using a [transform](https://www.elastic.co/guide/en/elasticsearch/reference/7.13/transform-apis.html) to create a separate index with joined up documents.
Someone might be able to provide some more detailed guidance if you provide additional details about your data, query and use case.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 30, 2021, 12:12pm UTC](https://discuss.elastic.co/t/merge-data-on-field-bases/274745/3 "2021-06-30T12:12:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.