> SELECT * > FROM EMPLOYEE e > WHERE NOT EXISTS (SELECT * > FROM DEPENDENT d > WHERE e.PERSON_ID = d.PERSON_ID)
I'm don't think torque supports subqueries, but this is a cut-and-paste from MySQL's docs (since MySQL also does not support subqueries) : SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2); SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 where table1.id=table2.id); Can be rewritten as: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id IS NULL > thanks, > Maarten Roy -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
