I can not quite see how to do this. An example is probably the easiest way to demonstrate the desired result.
aTable ID aField 1 a 2 b 3 a 4 c 5 a 6 d 7 c 8 a 9 e If one where to count these records grouped by aField one would get the following results. a - 4 b - 1 c - 2 d - 1 e - 1 I want to select all the records where the count is greater then 1, i.e. records 1,3,4,5,7 and 8. Can anybody point out what I am missing here? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2983 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
