i would like to write a sql query that can find where a certain 'id' has a duplicate. i don't want to see the ids where there is only one instance of it. (for example, show me 20010001 if there are 2 of them in the db, and don't show me 20010002 if there is only one of them in the db). anyone have any suggestions? thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com