# \[Kibana 7.10\] how to match item in two index patten
**URL:** https://discuss.elastic.co/t/kibana-7-10-how-to-match-item-in-two-index-patten/283730
**Category:** Kibana
**Created:** [September 9, 2021, 4:37am UTC](https://discuss.elastic.co/t/kibana-7-10-how-to-match-item-in-two-index-patten/283730 "2021-09-09T04:37:24Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@cps598](https://discuss.elastic.co/u/cps598)
#### Post date: [September 9, 2021, 4:37am UTC](https://discuss.elastic.co/t/kibana-7-10-how-to-match-item-in-two-index-patten/283730/1 "2021-09-09T04:37:24Z")
I originally have two index patterns with one same item called user.id. Now I create one more index pattern which combines those two indexes. But I find that they just simply add one index after another, which includes two same user.id and doesn't satisfy my requirement.
I want to use user.id like a foreign key in SQL. After combination, I expect to get only one row with one user.id and all related information from the two indexes, and then show them in Kibana Data Table.
Are there any methods to achieve this goal?
Thanks!!
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [September 9, 2021, 5:52am UTC](https://discuss.elastic.co/t/kibana-7-10-how-to-match-item-in-two-index-patten/283730/2 "2021-09-09T05:52:45Z")
Please don't start multiple topics on the same question - [[Kibana 7.10] How to search from all Index Patten](https://discuss.elastic.co/t/kibana-7-10-how-to-search-from-all-index-patten/283721)
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [September 9, 2021, 5:52am UTC](https://discuss.elastic.co/t/kibana-7-10-how-to-match-item-in-two-index-patten/283730/3 "2021-09-09T05:52:48Z")