I've seen UNION used to join those two tables in queries. I'm imaginning something like: SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT borrowernumber) FROM ( SELECT issuedate,categorycode,borrowernumber FROM old_issues UNION ALL SELECT issuedate,categorycode,borrowernumber FROM issues ) LEFT JOIN borrowers USING (borrowernumber) GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode; But I'm no database expert, so use this with care. On Mon, Jan 9, 2012 at 1:12 PM, Cab Vinton <bibliwho@gmail.com> wrote:
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 _______________________________________________ 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/