Dan -
Try this -
Edit * FROM table +
WHERE primarykeycolumn IN +
(SELECT primarykeycolumn FROM table +
GROUP BY primarykeycolumn +
HAVING COUNT(*) > 1)
--------------------------------------------------------------------------
Sami Aaron
Hampshire Technology Group, LLC
6310 Lamar Ave, Suite 220
Overland Park, KS 66202
913-403-8100 Fax: 913-403-7689 Cell: 913-208-7205
http:\\www.hampshiretechnology.com
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: Dan Weissmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 1:04 PM
To: RBase List Server
Subject: having count
Am trying to recall the command that lets a user edit duplicate records. I
tried EDIT * FROM <table> HAVING COUNT <colID> > 1 but that brings up all
records in the table.
Anyone out there game for slamming a textbook on my head?
Dan
