# Multiple indices with different fields
**URL:** https://discuss.elastic.co/t/multiple-indices-with-different-fields/141462
**Category:** Elasticsearch
**Created:** [July 25, 2018, 1:17am UTC](https://discuss.elastic.co/t/multiple-indices-with-different-fields/141462 "2018-07-25T01:17:47Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@arshadsa](https://discuss.elastic.co/u/arshadsa)
#### Post date: [July 25, 2018, 1:17am UTC](https://discuss.elastic.co/t/multiple-indices-with-different-fields/141462/1 "2018-07-25T01:17:48Z")
Hi All,
I know ES is not RDBMS and not possible to join but wanted to ask experts opinion here.
I want to pull data from two different indices (idx1, idx2) with different fields as below
query: match: idx1.fld1=idx2.fld2 AND idx1.fld3 = idx2.fldx4
Any suggestions here, plz.
Thank you
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 25, 2018, 7:26am UTC](https://discuss.elastic.co/t/multiple-indices-with-different-fields/141462/2 "2018-07-25T07:26:28Z")
I think you answered yourself.
Joins are not possible unless you use the parent child feature.
It's better to do the join at index time.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 22, 2018, 7:26am UTC](https://discuss.elastic.co/t/multiple-indices-with-different-fields/141462/3 "2018-08-22T07:26:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.