[Koha-devel] Active borrowers report

[Cab Vinton]

A couple years ago Jesse Weaver came up with this report for active
borrowers (i.e., patrons checking out materials):

	SELECT YEAR(issuedate), MONTH(issuedate), categorycode,
COUNT(DISTINCT borrowernumber)
	FROM old_issues
	LEFT JOIN borrowers USING (borrowernumber)
	GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode;

I'm wondering if the caveat he notes is still true:

	Because it uses old_issues, it won't include anything that's still
checked out; getting
	around that requires either ugly subqueries or running the report
with old_issues
	and issues and manually combining the results.

Is there a relatively easy way to modify the report so it includes
patrons who may still have items checked out?

Thanks for any assistance!

Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH

"Politeness and consideration for others is like investing pennies and
getting dollars back." Thomas Sowell