group_concat help

[blinks]

I have a long and complicated SQL query, which I've cut back to it's bare bones here -

 

SELECT
frsk.pid AS PID,
frsk.title AS TITLE,
group_concat(DISTINCT frsk_ismemberof.ismemberof ORDER BY 
frsk_ismemberof.ismemberof DESC SEPARATOR '|') AS COLLECTION

FROM frsk 
LEFT JOIN frsk_ismemberof ON pid=ismemberof_pid

WHERE date BETWEEN '2003-01-01 00:00:00' AND '2008-12-31 23:59:59'
GROUP BY pid

 

the query works as intended, above. However, the group_concat line is a collection of ID #s which I want to replace with ID names, using the following subquery -

 

select DISTINCT(frsk.title) from frsk, frsk_ismemberof 
where frsk.pid=frsk_ismemberof.ismemberof

 

However, I can't figure out how to incorporate the subquery into the group_concat line; I keep getting a "subquery has more than one line" message.

 

TIA

 

[fenway]

You can't do that -- join it in one more time.