# SQL Query with "NOT IN" keyword replacement in ES

**URL:** <https://discuss.elastic.co/t/sql-query-with-not-in-keyword-replacement-in-es/158455>\
**Category:** Elasticsearch\
**Created:** [November 28, 2018, 4:50am UTC](https://discuss.elastic.co/t/sql-query-with-not-in-keyword-replacement-in-es/158455 "2018-11-28T04:50:06Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![W.anjum](https://avatars.discourse-cdn.com/v4/letter/w/a9a28c/32.png) [@W.anjum](https://discuss.elastic.co/u/W.anjum)\
**Post date:** [December 5, 2018, 10:23am UTC](https://discuss.elastic.co/t/sql-query-with-not-in-keyword-replacement-in-es/158455/6 "2018-12-05T10:23:09Z")

</div>

It doesn't matter its SQL or elastic search query. I need a solution for this logic:  
[ES Logic](https://discuss.elastic.co/t/elastic-search-query-building-logic/156693?u=w.anjum)

---

_[View the full topic](https://discuss.elastic.co/t/sql-query-with-not-in-keyword-replacement-in-es/158455)._