Hi, I am using PB API and have two classes Activity and Schedule with 1:N association. Both are declared in the repository-user.xml with a collection-descriptor as reference. Now I want to process a query which results in a collection with all activities where no schedule has been set. I have read the Query examples carefully but I just don't get it. Could someone help me with the following sql statement:
SELECT * FROM Activity As act WHERE act.ACTIVITY_ID NOT IN (SELECT ACTIVITY_ID FROM SCHEDULE); Looks so simple, but I cannot figure it out. How to set up this statement using the Criteria class? Hope someone can help. thanks, Dirk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
