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

:-) or even...

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

I can't think why you would need to include the id/lexicon_id twice in
your results so I left it out.

• Next in forum: Re: help - isolate specific xml from mySQL entry?
• Prev in forum: Re: Joining many results from one table with one result from another in one query
• Thread view: Re: Joining many results from one table with one result from another in one query

[Reply to this message]