# How can I get the data from two types in elastic search?
**URL:** https://discuss.elastic.co/t/how-can-i-get-the-data-from-two-types-in-elastic-search/34120
**Category:** Kibana
**Created:** [November 9, 2015, 1:38am UTC](https://discuss.elastic.co/t/how-can-i-get-the-data-from-two-types-in-elastic-search/34120 "2015-11-09T01:38:12Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@verystrongjoe](https://discuss.elastic.co/u/verystrongjoe)
#### Post date: [November 9, 2015, 1:38am UTC](https://discuss.elastic.co/t/how-can-i-get-the-data-from-two-types-in-elastic-search/34120/1 "2015-11-09T01:38:12Z")
I have two types in elastic search. One type is for saving the request information table and other one is for saving the id, value information about method full information. I want to show the request information table using mapped two types. How can I get the data from two types where it is in elastic search on the kibana? Or Is there any other way to implement this? Elastic search can provide the query time join for the relation parent and child. It may create the view that parent and child information have. Can I fetch this view in the kbana? please Help me. Thanks..
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 9, 2015, 1:45am UTC](https://discuss.elastic.co/t/how-can-i-get-the-data-from-two-types-in-elastic-search/34120/2 "2015-11-09T01:45:02Z")
You cannot join in ES (or nosql in general).
Ideally you should be adding the information at index time.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:09pm UTC](https://discuss.elastic.co/t/how-can-i-get-the-data-from-two-types-in-elastic-search/34120/3 "2017-07-06T14:09:35Z")