# Can we search from multiple indexs and assemble their？ **URL:** \ **Category:** Elasticsearch\ **Tags:** es-hadoop\ **Created:** [February 19, 2021, 7:30am UTC](https://discuss.elastic.co/t/can-we-search-from-multiple-indexs-and-assemble-their/264804 "2021-02-19T07:30:12Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Anyzm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anyzm/32/84164_2.png) [@Anyzm](https://discuss.elastic.co/u/Anyzm)\ **Post date:** [February 19, 2021, 7:30am UTC](https://discuss.elastic.co/t/can-we-search-from-multiple-indexs-and-assemble-their/264804/1 "2021-02-19T07:30:12Z")
can we search from multiple indexs and assemble their？ eg: there are two index person and car， there are a field called sex in index person and a field called color in index car，we want to search the women who own black cars in one request。 how can we make it？ ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [February 19, 2021, 7:55am UTC](https://discuss.elastic.co/t/can-we-search-from-multiple-indexs-and-assemble-their/264804/2 "2021-02-19T07:55:31Z")
That would require a join across indices which Elasticsearch does not support. You therefore probably need to restructure how you store data, e.g. by denormalizing. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 19, 2021, 7:55am UTC](https://discuss.elastic.co/t/can-we-search-from-multiple-indexs-and-assemble-their/264804/3 "2021-03-19T07:55:39Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.