Posted by Captain Paralytic on 06/14/07 15:21

On 14 Jun, 15:56, "cluthz" <WHATEEVVE...@by.co.uk> wrote:
| But how do I know which row will be used when a customer has more
then one
| email address? Or to ask it another way, which email address will be
| displayed.

You don't as it is explained here:
http://dev.mysql.com/tech-resources/articles/debunking-group-by-myths.html

If you have a need for a specific one of the email addresses then do
something to identifyu and select that one.

If you want the first/last newest/oldest, ... then the Strawbery Query
is your friend.

[Back to original message]