EOQualifier - Query - "Not Exists" or "not in" query

"alisalimi74" <[email protected]> Fri, 25 Aug 2006 16:02:42 -0000
Newsgroups gmane.comp.web.webobjects.newbies
Message-ID <[email protected]>
Hi,
Anybody know how can I implement "not exists" part of my query in
EOQualifier?
I have 2 tables A and B. I want to say select * from A where A_ID not
in (select A_ID from B).
What can qualifier1 be?

EOQualifier secQual = new EOAndQualifier( new NSArray(new Object[]
{qualifier1}));
fetchSpec = new EOFetchSpecification("A", secQual, null);
fetchSpec.setRefreshesRefetchedObjects(true);
pickList = new NSMutableArray
editingContext.objectsWithFetchSpecification(fetchSpec));

Thanks






 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/webobjects-newbies/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/