I am constantly amazed by how good HOF lists are! I got the answer by
just typing out the question.
I used a join to a sub-select to get the desired records
SELECT
ID,
A.aField,
B.aField
FROM
aTable A INNER JOIN
(SELECT
aField
FROM
aTable
GROUP BY
aField
HAVING
COUNT(*) > 2) B ON A.aField = B.aField
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2984
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
