# Fetching the results from two indexes - how to? **URL:** \ **Category:** Elasticsearch\ **Created:** [December 19, 2013, 12:35am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942 "2013-12-19T00:35:24Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Bijuv\_V](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@Bijuv\_V](https://discuss.elastic.co/u/Bijuv_V)\ **Post date:** [December 19, 2013, 12:35am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/1 "2013-12-19T00:35:24Z")
I have some data indexed in Index 1 - for e.g - I have all of the routes of a train listed in Index 1. I can search the train that goes in a particular route by querying the index 1. This is ok. I have another index that has has the details of all trains that are under maintenance. So from Index 2, I can get all trains that are under maintenance. Now the question is : How do I write a query that will list the routes of trains that are under maintenance and 2) list the routes of the train that are not under maintenance. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6e71f8c1-36fe-45fe-85a8-7122e006d53f%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6e71f8c1-36fe-45fe-85a8-7122e006d53f%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Bijuv\_V](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@Bijuv\_V](https://discuss.elastic.co/u/Bijuv_V)\ **Post date:** [December 19, 2013, 9:37am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/2 "2013-12-19T09:37:49Z")
Can you suggest if this is possible or this is not possible using query DSL ? If you think its possible, a pointer would also help. Op donderdag 19 december 2013 01:35:24 UTC+1 schreef Bijuv V: > I have some data indexed in Index 1 - for e.g - I have all of the routes > of a train listed in Index 1. > > I can search the train that goes in a particular route by querying the > index 1. This is ok. > > I have another index that has has the details of all trains that are under > maintenance. > > So from Index 2, I can get all trains that are under maintenance. > > Now the question is : > > How do I write a query that will list the routes of trains that are under > maintenance and 2) list the routes of the train that are not under > maintenance. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![johtani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/johtani/32/44956_2.png) [@johtani](https://discuss.elastic.co/u/johtani)\ **Post date:** [December 19, 2013, 10:02am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/3 "2013-12-19T10:02:08Z")
Hi, Do you want to search across multiple indexes (index1 and index2) ? If do that, you try following query or comma separate notation. - Indices query [Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-indices-query.html) - Multiple Indices [Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/multi-index.html) Does it make sense? -- Jun Ohtani 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > Can you suggest if this is possible or this is not possible using query > DSL ? If you think its possible, a pointer would also help. > > Op donderdag 19 december 2013 01:35:24 UTC+1 schreef Bijuv V: > > > I have some data indexed in Index 1 - for e.g - I have all of the routes > > of a train listed in Index 1. > > > > I can search the train that goes in a particular route by querying the > > index 1. This is ok. > > > > I have another index that has has the details of all trains that are > > under maintenance. > > > > So from Index 2, I can get all trains that are under maintenance. > > > > Now the question is : > > > > How do I write a query that will list the routes of trains that are under > > maintenance and 2) list the routes of the train that are not under > > maintenance. > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com) > > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ## -- Jun Ohtani blog : [http://blog.johtani.info](http://blog.johtani.info) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Bijuv\_V](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@Bijuv\_V](https://discuss.elastic.co/u/Bijuv_V)\ **Post date:** [December 19, 2013, 10:12am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/4 "2013-12-19T10:12:19Z")
Thanks for pointing to multiple indexes. I went through the documentation and it doesn't tell as to how to join the data from 2 indices. It looks like giving the result that matches certain queries from both the indexes. For e.g. Wow word from different comment sources. On Thu, Dec 19, 2013 at 11:02 AM, Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com) wrote: > Hi, > > Do you want to search across multiple indexes (index1 and index2) ? > > If do that, you try following query or comma separate notation. > > - Indices query > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-indices-query.html) > > - Multiple Indices > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/multi-index.html) > > Does it make sense? > > -- > Jun Ohtani > > 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > > > Can you suggest if this is possible or this is not possible using query > > DSL ? If you think its possible, a pointer would also help. > > > > Op donderdag 19 december 2013 01:35:24 UTC+1 schreef Bijuv V: > > > > > I have some data indexed in Index 1 - for e.g - I have all of the > > > routes of a train listed in Index 1. > > > > > > I can search the train that goes in a particular route by querying the > > > index 1. This is ok. > > > > > > I have another index that has has the details of all trains that are > > > under maintenance. > > > > > > So from Index 2, I can get all trains that are under maintenance. > > > > > > Now the question is : > > > > > > How do I write a query that will list the routes of trains that are > > > under maintenance and 2) list the routes of the train that are not under > > > maintenance. > > > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com) > > > . > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > ## -- > > Jun Ohtani > blog : [http://blog.johtani.info](http://blog.johtani.info) > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > [https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe](https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe). > To unsubscribe from this group and all its topics, send an email to > [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com) > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS\_45tOh8obTg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS_45tOh8obTg%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![johtani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/johtani/32/44956_2.png) [@johtani](https://discuss.elastic.co/u/johtani)\ **Post date:** [December 19, 2013, 10:24am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/5 "2013-12-19T10:24:35Z")
Hi, Do you want to search parent-child data structure? Like these? > **[Elastic — The Search AI Company](https://www.elastic.co)** > > Power insights and outcomes with The Elastic Search AI Platform. See into your data and find answers that matter with enterprise solutions designed to help you accelerate time to insight. Try Elastic ... > **[Fun with elasticsearch's children and nested documents - Space Vatican](https://www.spacevatican.org/2012/6/3/fun-with-elasticsearch-s-children-and-nested-documents/)** > > When you’re indexing data, the world is rarely as simple as each document existing in isolation. Sometimes, you’re better off … 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > Thanks for pointing to multiple indexes. I went through the documentation > and it doesn't tell as to how to join the data from 2 indices. > > It looks like giving the result that matches certain queries from both the > indexes. For e.g. Wow word from different comment sources. > > On Thu, Dec 19, 2013 at 11:02 AM, Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com) wrote: > > > Hi, > > > > Do you want to search across multiple indexes (index1 and index2) ? > > > > If do that, you try following query or comma separate notation. > > > > - Indices query > > > > [Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-indices-query.html) > > > > - Multiple Indices > > > > [Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/multi-index.html) > > > > Does it make sense? > > > > -- > > Jun Ohtani > > > > 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > > > > > Can you suggest if this is possible or this is not possible using query > > > DSL ? If you think its possible, a pointer would also help. > > > > > > Op donderdag 19 december 2013 01:35:24 UTC+1 schreef Bijuv V: > > > > > > > I have some data indexed in Index 1 - for e.g - I have all of the > > > > routes of a train listed in Index 1. > > > > > > > > I can search the train that goes in a particular route by querying the > > > > index 1. This is ok. > > > > > > > > I have another index that has has the details of all trains that are > > > > under maintenance. > > > > > > > > So from Index 2, I can get all trains that are under maintenance. > > > > > > > > Now the question is : > > > > > > > > How do I write a query that will list the routes of trains that are > > > > under maintenance and 2) list the routes of the train that are not under > > > > maintenance. > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "elasticsearch" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > > To view this discussion on the web visit > > > > [https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com) > > > > . > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > ## -- > > > > Jun Ohtani > > blog : [http://blog.johtani.info](http://blog.johtani.info) > > > > -- > > You received this message because you are subscribed to a topic in the > > Google Groups "elasticsearch" group. > > To unsubscribe from this topic, visit > > [https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe](https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe). > > To unsubscribe from this group and all its topics, send an email to > > [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com) > > . > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS\_45tOh8obTg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS_45tOh8obTg%40mail.gmail.com) > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ## -- Jun Ohtani blog : [http://blog.johtani.info](http://blog.johtani.info) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5wXnu%2Bwk7MrZh56g-s1J-Kse6d5gBXQzdG42nQ5YEEQYQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5wXnu%2Bwk7MrZh56g-s1J-Kse6d5gBXQzdG42nQ5YEEQYQ%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\ **Post date:** [December 19, 2013, 3:16pm UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/6 "2013-12-19T15:16:12Z")
Hey, check out this presentation by Martijn about document relations with elasticearch. It should give you a couple of pointers > **[Document relations at OSSC](https://speakerdeck.com/mvgroningen/document-relations-at-ossc)** > > Introduces the various ways in Elasticsearch to model your data in a relational manner. Discusses nested field type and parent-child features. > > Presented at OSS basis tech week. Alternatively, watch the video from last years berlin buzzwords: > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. --Alex On Thu, Dec 19, 2013 at 11:24 AM, Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com) wrote: > Hi, > > Do you want to search parent-child data structure? > Like these? > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/blog/managing-relations-inside-elasticsearch/) > > [Fun with elasticsearch's children and nested documents - Space Vatican](http://www.spacevatican.org/2012/6/3/fun-with-elasticsearch-s-children-and-nested-documents/) > > 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > > > Thanks for pointing to multiple indexes. I went through the documentation > > and it doesn't tell as to how to join the data from 2 indices. > > > > It looks like giving the result that matches certain queries from both > > the indexes. For e.g. Wow word from different comment sources. > > > > On Thu, Dec 19, 2013 at 11:02 AM, Jun Ohtani [johtani@gmail.com](mailto:johtani@gmail.com) wrote: > > > > > Hi, > > > > > > Do you want to search across multiple indexes (index1 and index2) ? > > > > > > If do that, you try following query or comma separate notation. > > > > > > - Indices query > > > > > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-indices-query.html) > > > > > > - Multiple Indices > > > > > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/multi-index.html) > > > > > > Does it make sense? > > > > > > -- > > > Jun Ohtani > > > > > > 2013/12/19 Bijuv V [vvbiju2005@gmail.com](mailto:vvbiju2005@gmail.com) > > > > > > > Can you suggest if this is possible or this is not possible using query > > > > DSL ? If you think its possible, a pointer would also help. > > > > > > > > Op donderdag 19 december 2013 01:35:24 UTC+1 schreef Bijuv V: > > > > > > > > > I have some data indexed in Index 1 - for e.g - I have all of the > > > > > routes of a train listed in Index 1. > > > > > > > > > > I can search the train that goes in a particular route by querying the > > > > > index 1. This is ok. > > > > > > > > > > I have another index that has has the details of all trains that are > > > > > under maintenance. > > > > > > > > > > So from Index 2, I can get all trains that are under maintenance. > > > > > > > > > > Now the question is : > > > > > > > > > > How do I write a query that will list the routes of trains that are > > > > > under maintenance and 2) list the routes of the train that are not under > > > > > maintenance. > > > > > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > Groups "elasticsearch" group. > > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > > an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > > > To view this discussion on the web visit > > > > > [https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/334ce1d9-c7bb-43a6-b6c6-ae357ce1b86a%40googlegroups.com) > > > > > . > > > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > > > ## -- > > > > > > Jun Ohtani > > > blog : [http://blog.johtani.info](http://blog.johtani.info) > > > > > > -- > > > You received this message because you are subscribed to a topic in the > > > Google Groups "elasticsearch" group. > > > To unsubscribe from this topic, visit > > > [https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe](https://groups.google.com/d/topic/elasticsearch/9HeWGY25HgU/unsubscribe). > > > To unsubscribe from this group and all its topics, send an email to > > > [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5xFBqkNg6yTzCKtLe0Gcomk45LmcQoFDcLJopHVsMO5OQ%40mail.gmail.com) > > > . > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS\_45tOh8obTg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALU-2jzahWiNxMmFhFzPgW8DCLLDp-VUi1SS6JS_45tOh8obTg%40mail.gmail.com) > > . > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > ## -- > > Jun Ohtani > blog : [http://blog.johtani.info](http://blog.johtani.info) > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CAPW8A5wXnu%2Bwk7MrZh56g-s1J-Kse6d5gBXQzdG42nQ5YEEQYQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPW8A5wXnu%2Bwk7MrZh56g-s1J-Kse6d5gBXQzdG42nQ5YEEQYQ%40mail.gmail.com) > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAGCwEM-B3SZhaxB0E5ALpXTwLkicGA1tFHopozzLNEv7mbgfjA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGCwEM-B3SZhaxB0E5ALpXTwLkicGA1tFHopozzLNEv7mbgfjA%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:00am UTC](https://discuss.elastic.co/t/fetching-the-results-from-two-indexes-how-to/14942/7 "2017-07-06T02:00:12Z")