varchar, sir.
> -----Original Message----- > From: Wesley Furgiuele [mailto:[EMAIL PROTECTED] > Sent: July 13, 2004 1:14 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED] > Subject: Re: Why this query doesn't group the email addresses? > > 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]
