Thanks for the reply! Unfortunately, I don't have a function called group_concat available.
On Oct 27, 6:34 pm, Grzegorz Sobanski <[email protected]> wrote: > * DrewA <[email protected]> [2011-10-27 22:46]: > > > SELECT > > t.id AS Ticket, > > t.summary AS Summary, > > tc.newvalue AS Comments > > FROM ticket t > > LEFT JOIN ticket_change tc ON t.id=tc.ticket > > Untested, but should work: > > SELECT > t.id AS Ticket, > t.summary AS Summary, > group_concat(tc.newvalue, ', ') AS Comments > FROM ticket t > LEFT JOIN ticket_change tc ON t.id=tc.ticket > GROUP BY t.id, t.summary > > greets > > -- > silk -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
