Dan,
Try this:
EDIT * FROM <table> WHERE <UniqueCol> IN (SELECT DISTINCT <UniqueCol> FROM
<table> GROUP BY <UniqueCol> HAVING COUNT <ColID> > 1)
Rommel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Dan Weissmann
Sent: Friday, May 25, 2001 11:04 AM
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
