You are doing an implicit group by of first, last as well as your explicit group by of email.
So you could have two records with the same e-mail address generate two records with your group by Justin Time [EMAIL PROTECTED] Justin Credible [EMAIL PROTECTED] --DUPE-- Case differences between the records could also cause dupes. If case differences are causing it then do select lower(first), lower(last), lower(email) ... group by lower(first), lower(last), lower(email) --- Wesley Furgiuele <[EMAIL PROTECTED]> wrote: > What type of field is the email field? > > Wes > > On Jul 13, 2004, at 11:04 AM, Aaron Wolski wrote: > > > Hey all, > > > > Got this query: > > > > SELECT first,last,email FROM CustomerTable AS t1, > > OrderTable AS t2, CartTable AS t3 WHERE > t2.cart_id=t3.cart_id > > AND t1.id=t2.customer_index AND t3.submitted='1' > AND > > t3.product_index='1' AND t3.quantity>0 > > GROUP BY t1.email ORDER BY t1.first,t1.last > > > > For some strange reason it doesn't seem to group > the email addresses. > > I'd be hard pressed to find every occurrence out > of 1000 records, but I > > DID quickly spot two exact same records which > means the email address > > was not grouped. > > > > What can I do or where did I go wrong? > > > > Thanks! > > > > Aaron > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
