-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, May 01, 2006 16:55
To: Dirk Bremer
Cc: mysql@lists.mysql.com
Subject: Re: Finding duplicates, etc.
Dirk,
I would like to know where there ar duplicate accounts that
do not have
duplicate
I have the following table:
*Column Information For - production.group15034_I*/
FieldType Collation NullKey
Default Extra Privileges Comment
---
Dirk,
I would like to know where there ar duplicate accounts that do not have
duplicate addresses. I think that at this point in time that these are
included in the first query. I would like to separate these out to
report on them.
How about ...
select account,ident,address
from group15034_i