I have a situation where I have an entity "Item" that is related to many "Picture" items. I'm trying to fetch all "Items" that have no related "Pictures"...in sql I would write a query like:

SELECT * FROM Item i
LEFT JOIN Picture p ON i.id = p.itemID
WHERE p.id is null

In other words I'd like to select all where Item.pictures.count == 0. What's the easiest / best / most correct way to do this with EO?

Thanks!

John


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to