Baron Schwartz wrote:
I'm tempted to solve this using a view or two, but would like to know if there's a better way.GROUP_CONCAT() takes an optional DISTINCT modifier, and that might do what you're looking for.
It sure does the trick. I'll use that, I was afraid that I was missing something fundamental in the joins.
Thanks, Morten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
