* 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.
