Write a query that joins a table to itself and look for matching values but with different PKs.
That logic should work... Mike ----- Original Message ----- From: "Wurst, Keith D." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 2003 10:10 AM Subject: sql question > 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