select * from ticket t left join ticket_custom c1 on t.id = c1.ticket and c1.name = '<field_name>'
is the basic join you have to make On 9/25/07, David <[EMAIL PROTECTED]> wrote: > > > How do I show custom fields in query results? > > I'm using 0.10.4. > > > > > -- Jeff Webb [EMAIL PROTECTED] http://boowebb.com/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
