Hello,
I am having trouble creating a fetch specification selects duplicate
objects but bases the comparison on only a few select fields. For
instance a fetch specification that mimics the follow SQL query:
SELECT school_number, first_name, last_name
FROM "cms"."ms_contestant"
WHERE (contest_id = 0x000081618cb5000007d202000000011f85e471540a2b2f43
OR contest_id = 0x000081618cb5000007d204000000011f85e471540a2b2f43
OR contest_id = 0x000081618cb5000007d206000000011f85e471540a2b2f43)
GROUP BY school_number, first_name, last_name
HAVING COUNT(*) > 1
Is there a way to do this?
Regards,
Jeff
_______________________________________________
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]
