Can someone tell me the correct SQL to get a count of active borrowers? Do I need to pull from issues or old_issues and what is the differences and or reasoning. We used the SQL from Koha SQL Reports Library "List Active Patrons by Category for a Specific Month" Code = SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT borrowernumber) FROM old_issues LEFT JOIN borrowers USING (borrowernumber) GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode Also do we want to use DISTINCT borrowernumber or just borrowernumber? Thanks, Lola McKee Tech Systems Specialist Salina Public Library 785-825-4624 Ext. 239 <http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/917121931 39?ref=s> P Please consider the environment before printing this e-mail.
