Dear Friends,
I want to get the list of all users registered in Trac with the number
of tickets belongs to each users.
The user name should be displayed even though there is no ticket
belongs to him/her.
This is the query I try:
SELECT
sid, count(*)
FROM
session
LEFT OUTER JOIN ticket
WHERE sid=reporter
GROUP BY sid
However, this does not gives the user names without tickets.
This was proven when I got 56 for:
SELECT count(*) from (
SELECT
sid, count(*)
FROM
session
LEFT OUTER JOIN ticket
WHERE sid=reporter
GROUP BY sid)
while I am getting 78 for:
SELECT count(*) from sid.
Where I do the mistake?
Thanks in advance.
Regards,
Sumith
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
