# SQL LEFT JOIN with WHERE issue

**URL:** <https://forum.opensearch.org/t/sql-left-join-with-where-issue/4415>\
**Category:** SQL\
**Created:** [December 17, 2020, 10:46am UTC](https://forum.opensearch.org/t/sql-left-join-with-where-issue/4415 "2020-12-17T10:46:42Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![daichen](https://avatars.discourse-cdn.com/v4/letter/d/c4cdca/32.png) [@daichen](https://forum.opensearch.org/u/daichen)\
**Post date:** [January 15, 2021, 10:39pm UTC](https://forum.opensearch.org/t/sql-left-join-with-where-issue/4415/2 "2021-01-15T22:39:08Z")

</div>

@j.f Thanks for reporting the issue! Unfortunately, post-filter/aggregate after join operation is not supported yet. We’re evaluating and will be adding more comprehensive JOIN support in our new query engine in future. Thanks!

---

_[View the full topic](https://forum.opensearch.org/t/sql-left-join-with-where-issue/4415)._