Re: Join Issues

[Peter Brawley]

Is this what you're looking for?

select tx.id, tx.status, tx.starts, tx.started, tx.due, tx.resolved, x.`Dept-Reason`
from tickets tx
join (
  select t.id, group_concat(o.content order by o.customField) as 'Dept-Reason'
  from tickets t
  left join objectcustomfieldvalues o on t.id = o.objectid 
  group by t.id
) x using(id)
order by tx.id;