Group_concat Question

[gmorris]

I am attempting to pull data from multiple tables into a resultset that
I can use as an Excel spreadsheet for reporting. Here is my query so
far:

SELECT b.bug_id,p.real name as 'Assigned'
,bug_status,b.r esolution,b.sho rt_desc,l.thete xt
as 'Description/Comments',b.cre ation_ts as 'Opened',b.delt a_ts as 'Last
Update'
FROM bugs b, longdescs l, profiles p
WHERE b.bug_id=l.bug_ id and b.assigned_to=p .userid and b.bug_status in
('new','assigne d')
group by b.bug_id
order by bug_status,Open ed

This produces what I need, except that for the field 'thetext' there is
a many to one relationship back to bug_id. I'm trying to use the
GROUP_CONCAT command, but when I add it:

SELECT b.bug_id,p.real name as 'Assigned'
,bug_status,b.r esolution,b.sho rt_desc,
Group_Concat (l.thetext) as 'Description/Comments',b.cre ation_ts as
'Opened',b.delt a_ts as 'Last Update'
FROM bugs b, longdescs l, profiles p
WHERE b.bug_id=l.bug_ id and b.assigned_to=p .userid and b.bug_status in
('new','assigne d')
group by b.bug_id
order by bug_status,Open ed

I get an error 1064 saying that the syntax is wrong near (l.thetext) on
line 2. I've tried quite a few variations with the parenthesis and
order but nothing seems to help.

Any suggestions or hints would be greatly appreciated! :-)

Thanks,
Gordon