KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have tried to write a query statement with a subquery and an IN expression for many times, but I have never succeeded. I always get the exception, "Syntax error near keyword 'IN'". The query statement was build like this, SELECT t0.ID, t0.NAME FROM EMPLOYEE t0 WHERE IN (SELECT ? FROM PROJECT t2, EMPLOYEE t1 WHERE ((t2.NAME = ?) AND (t1.ID = t2.project))) I know the word before IN is missing. Have you ever written such a query? Any suggestion?
Tags (comma-separated)
Save Edits
Cancel