EOQualifier - Query from database - "not in" or "not exists"

Ali Salimi <[email protected]> Fri, 25 Aug 2006 14:51:19 -0700 (PDT)
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
  


 		
---------------------------------
 All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.