Hi again,
http://jakarta.apache.org/ojb/apidocs/org/apache/ojb/broker/query/Criteria.html#addNotIn(java.lang.String,%20java.util.Collection) Sub-selects are not supported ! cheers, Thomas Edson Carlos Ericksson Richter wrote: > Hi! > > I know that this is a just very begginner question, but since I'm getting my >connection being kick-off every 60 seconds, I can't search achives... And yes, please >don't blame me that this is not list members problem... > > Ok, to the question: I need to make a query of type "not in"... Using Person-Project >sample (tutorial 3), I need to issue > > select * from person where person_id not in (select person_id from project_person) > > Thanks to all! > > Edson Richter > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
