Devart Forums

I have an SQL statement like this:

SELECT * FROM items WHERE id IN (SELECT id FROM sel)

What I got is an error indication there and error in SQL line 1 or
something like that.

How can I solve this or it is simple because dbexpress does not support
subqueries

Please check whether this query is executed properly in any other way. For example, try to execute it with SQL Server Management Studio, or with the standard dbExpress driver for SQL Server, or with ADO components. It is likely that there is something wrong with the query.