# "in query" is not yet supported
**URL:** https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568
**Category:** Elasticsearch
**Tags:** elastic-stack-sql
**Created:** [May 30, 2019, 3:26pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568 "2019-05-30T15:26:21Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Paul\_Yeung](https://discuss.elastic.co/u/Paul_Yeung)
#### Post date: [May 30, 2019, 3:26pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568/1 "2019-05-30T15:26:21Z")
When I try to use sql API to do the following:
select name from school where name in ( select name from teachers ) ;
ES complains that "in query" is not yet supported. This means I need to do this in query DSL. What is the equivalent in DSL?
Thanks!
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [May 30, 2019, 9:41pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568/2 "2019-05-30T21:41:21Z")
There isn't one at this stage sorry. I am not sure if there is something on the roadmap, as this essentially equates to 2 queries in the one request, which Elasticsearch currently doesn't handle.
---
### Author:  [@Paul\_Yeung](https://discuss.elastic.co/u/Paul_Yeung)
#### Post date: [May 31, 2019, 12:48pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568/3 "2019-05-31T12:48:44Z")
Thanks for the response
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 28, 2019, 12:48pm UTC](https://discuss.elastic.co/t/in-query-is-not-yet-supported/183568/4 "2019-06-28T12:48:51Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.