Yes sir. Exactly! A
> -----Original Message----- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: July 13, 2004 11:15 AM > To: 'Aaron Wolski '; '[EMAIL PROTECTED] ' > Subject: RE: Why this query doesn't group the email addresses? > > Were the records exactly the same? > > -----Original Message----- > From: Aaron Wolski > To: [EMAIL PROTECTED] > Sent: 7/13/04 10:04 AM > Subject: Why this query doesn't group the email addresses? > > 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]
