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 dupli

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