> Sir, your query doesn't work on my machine. I either have to GROUP BY
> orderID, or drop orderID and Name from the SELECT clause. I'm not
> sure what you're trying to do, so I don't know which to suggest.
Oh, sorry, I didn't check out what did I wrote... ;) Anyway, I got this work after
GROUP BY OrderID was added to the end of query line. And so it had to be, just forgot
it.
- Ville
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php