|
|
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.
Navigation:
[Reply to this message]
|