# How to search through two different index patterns with common field?
**URL:** https://discuss.elastic.co/t/how-to-search-through-two-different-index-patterns-with-common-field/220446
**Category:** Kibana
**Created:** [February 21, 2020, 7:24pm UTC](https://discuss.elastic.co/t/how-to-search-through-two-different-index-patterns-with-common-field/220446 "2020-02-21T19:24:37Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@emad101](https://discuss.elastic.co/u/emad101)
#### Post date: [February 21, 2020, 7:24pm UTC](https://discuss.elastic.co/t/how-to-search-through-two-different-index-patterns-with-common-field/220446/1 "2020-02-21T19:24:37Z")
Hello,
I am trying to get metric data from two different index pattern that have a common field. Suppose that I have
**Index A:** with fields a , b, c
**Index B:** with fields c, d, e
what I want to do is to get the sum of all records that have have the fields b,c,d,e. where c has to be the same in both indexes. Is this possible to do in the kibana canvas.
I know that the Sql Join function is not yet supported in the canvas, but is it possible to do this using Timelion?
---
### Author:  [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [February 26, 2020, 9:26pm UTC](https://discuss.elastic.co/t/how-to-search-through-two-different-index-patterns-with-common-field/220446/2 "2020-02-26T21:26:06Z")
Hello @emad101
You could reference `index-a-*,index-b-*` - I think you'd need to create a new index pattern depending upon which kibana tools you're using.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 25, 2020, 9:26pm UTC](https://discuss.elastic.co/t/how-to-search-through-two-different-index-patterns-with-common-field/220446/3 "2020-03-25T21:26:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.