# \#in-operator

**URL:** https://community.cdata.com/tag/in-operator/206.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [The query requires Id in the where clause: API Driver](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281)

<div class="topic-metadata">

**Author:** [@Altin](https://community.cdata.com/u/Altin)\
**Replies:** 0\
**Last updated:** [July 24, 2023, 5:19pm UTC](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281 "2023-07-24T17:19:14Z")

</div>

There are cases when the profile, could support IN operator in the Where clause, so you can run a query like: Select \* From \<MyTable\> Where \<MyId\> IN (Select Id from \<otherTable\>) or just simply: Select \* From \<MyTable\> …