RE: Finding duplicates, etc.

2006-05-02 Thread Dirk Bremer
-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

Re: Finding duplicates, etc.

2006-05-01 Thread Peter Brawley
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