And you know what, that one isn't in the report library so I added it for you. :)
You can see it here: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Active_Patrons Thanks! Liz Rea l...@nekls.org
<<inline: email_signature.jpeg>>
On Jan 9, 2012, at 2:36 PM, Mike Hafen wrote: > SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT > borrowernumber) > FROM ( > SELECT issuedate, borrowernumber FROM old_issues > UNION ALL > SELECT issuedate, borrowernumber FROM issues > ) AS all_issues > LEFT JOIN borrowers USING (borrowernumber) > GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
