Posted by zac.carey on 02/24/06 20:40

I suppose that should be...

SELECT lexicon_id, description, GROUP_CONCAT( keyword
ORDER BY keyword
SEPARATOR ', ' ) AS list
FROM keywords
LEFT JOIN lexicon ON lexicon_id = id
GROUP BY lexicon_id
ORDER BY lexicon_id

[Back to original message]