# How to visualize data from different tables in database in a single visualization

**URL:** <https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428>\
**Category:** Elasticsearch\
**Created:** [August 19, 2016, 7:11am UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428 "2016-08-19T07:11:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sudarshan](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@sudarshan](https://discuss.elastic.co/u/sudarshan)\
**Post date:** [August 19, 2016, 7:11am UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428/1 "2016-08-19T07:11:07Z")

</div>

Hello  
I have two tables indexed as two different types into the same index.

I need to create a single visualization out of two types based on a common column name.

How can I do that?

I am using "Enhanced Search Results" as visualization to view data.

Thanks.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 19, 2016, 7:37am UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428/2 "2016-08-19T07:37:37Z")

</div>

What sort of visualisation?

> [@sudarshan](#):
>
> Enhanced Search Results

What is this exactly?

---

<div class="post-metadata">

**Author:** ![sudarshan](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@sudarshan](https://discuss.elastic.co/u/sudarshan)\
**Post date:** [August 19, 2016, 9:06am UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428/3 "2016-08-19T09:06:38Z")

</div>

It is a type of visualization in kibi

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 19, 2016, 10:13pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428/4 "2016-08-19T22:13:12Z")

</div>

Then you should ask the kibi developers, we don't support that sorry.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 10:26pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-tables-in-database-in-a-single-visualization/58428/5 "2017-07-05T22:26:32Z")

</div>