Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?

[Roland Bouman]

Hi Phil,

you're sorry? Man, I'm sorry, it was never my intention to overwhelm you.
I am glad you solved you're problem, but I would've liked to have helped you properly.

Anyway, would you please tell me, did this:

select a.a_name
from table_a a
inner join a_b_assoc ab
on a.id = ab.a_id
inner join table_b b
on ab.b_id = b.id
group by a_name
order by group_concat(b.b_name);

sort your data right?

If not, can you please post a sample that shows the result you would want the query to return?

TIA,
Roland.