Yea that did the trick, thanks Claude. I deleted 62 duplicates. As I said before, not really all that significant but once I started on doing it, I didn't want to let go of the problem until you solved it for me <g>
Thanks Cheers Mike Kear Windsor, NSW, Australia 0422 985 585 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, 13 January 2008 2:32 PM To: SQL Subject: Re: SQL to identify duplicates Sorry, I knew I have solved this problem once, but I just picked up the wrong query. How about this one: SELECT BanID FROM GuestbookBans WHERE AuthorsIP IN (SELECT AuthorsIP FROM GuestbookBans GROUP BY AuthorsIP HAVING count(AuthorsIP) > 1) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3019 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
