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

[Phil Powell]

Ok, first of all, I ran your simple query, and here are the results

mysql> select s.student_first_name
-> , s.student_last_name
-> , group_concat(
-> e.ethnicity_name
-> order by e.ethnicity_name
-> )
-> from student s
-> inner join student_ethnicity_interest_assoc s2e
-> on s.id = s2e.student_id
-> inner join ethnicity e
-> on s2e.ethnicity_id = e.id
-> group by s.student_first_name
-> , s.student_last_name
-> order by s.student_first_name
-> , s.student_last_name
-> , group_concat(
-> e.ethnicity_name
-> order by e.ethnicity_name
-> ) ;
ERROR 1111 (HY000): Invalid use of group function

---------------------------------------------------------------------------

I don't think this is a legal query in MySQL 4.1.12, sorry :(

Phil