# Elastic search complex query

**URL:** <https://discuss.elastic.co/t/elastic-search-complex-query/301399>\
**Category:** Elasticsearch\
**Created:** [April 2, 2022, 7:47pm UTC](https://discuss.elastic.co/t/elastic-search-complex-query/301399 "2022-04-02T19:47:19Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**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:** [April 2, 2022, 8:14pm UTC](https://discuss.elastic.co/t/elastic-search-complex-query/301399/2 "2022-04-02T20:14:51Z")

</div>

Have a look at the approach recommended in [this thread](https://discuss.elastic.co/t/reference-tables-in-elastic/301369). Elasticsearch does not support joins so this is generally does by enriching at index time rather than joining at query time.

---

_[View the full topic](https://discuss.elastic.co/t/elastic-search-complex-query/301399)._