Subqueries with dbExpress

velocity766 · Post by **velocity766** » Wed 30 Apr 2008 18:24

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

Antaeus · Post by **Antaeus** » Mon 05 May 2008 12:04

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.