On Mar 2, 2007, at 11:02 PM, Amanda Kraus wrote:
> An inner join? The help guide says to use an left outer join which
> is what I attempted (and it failed) - if its supposed to be an
> inner join the guide should really be changed.
If you want only tickets that have the custom field set (so tickets
made after the field was created), an inner join will work fine. If
you want all tickets, and then the custom records if any exist, you
want an left join. In either case make sure you specified the right
column names ("id" in ticket matched to "ticket" in ticket_custom).
--Noah
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
