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/