# Join two indices using alias
**URL:** https://discuss.elastic.co/t/join-two-indices-using-alias/162490
**Category:** Elasticsearch
**Created:** [December 31, 2018, 9:49am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490 "2018-12-31T09:49:03Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Loki](https://discuss.elastic.co/u/Loki)
#### Post date: [December 31, 2018, 9:49am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490/1 "2018-12-31T09:49:03Z")
Hi,
I am still newbie in elasticsearch and I have also read that we cannot join two indices.
But is it possible to use alias in this case? I mean, can we join indices using alias?
Or is there any alternative or workaround for this?
Thanks,
Loki
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [December 31, 2018, 9:50am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490/2 "2018-12-31T09:50:46Z")
You can query across multiple indices by specifying multiple index names or using aliases, but Elasticsearch does not support joins. It would be easier to help if you could describe what your data looks like and what you are trying to do.
---
### Author:  [@Loki](https://discuss.elastic.co/u/Loki)
#### Post date: [December 31, 2018, 10:02am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490/3 "2018-12-31T10:02:36Z")
My POCO data looks something like below
```
Employee
{
Employee_ID int;
First_Name string;
Last_Name string;
Dept_ID int;
}
Department
{
Dept_ID int;
Dept_Name string;
Dept_Region string;
}
```
I was hoping to create two indices for Employee and Department and join using Dept\_ID in order to get all records from both the indices.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [December 31, 2018, 10:05am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490/4 "2018-12-31T10:05:07Z")
That kind of joins is not supported in Elasticsearch. A common way to get around this would be to denormalise the data and store department information with the employee.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 28, 2019, 10:05am UTC](https://discuss.elastic.co/t/join-two-indices-using-alias/162490/5 "2019-01-28T10:05:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.