然后我需要在返回的记录集上执行进一步的SELECT.我试过这个(简化为了清晰)：

SELECT * FROM Studies
WHERE Id = '2' OR Id = '3' OR Id = '7';

SELECT * FROM Studies
WHERE (Name = 'Test')
  AND Id IN (SELECT * FROM Studies WHERE Id = '2' OR Id = '3' OR Id = '7');

但我不断收到以下sql错误：

Only a single result allowed for a SELECT that is part of an expression

我哪里错了？如果从我的代码中看不出来 – 我对数据库编程比较陌生.

谢谢