EDIT * FROM tablename +
WHERE ColThatShouldNotBeDuped IN +
(SELECT SameColumn +
FROM SameTableName +
GROUP BY SameColumn +
HAVING COUNT (*) > 1)
You can't have a HAVING that makes sense, unless you first have a
GROUP BY.
Bill
On Fri, 25 May 2001 13:04:21 -0500, Dan Weissmann wrote:
>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
>
