[Koha] Report: patrons with recent checkouts
Chad Roseburg
croseburg at ncrl.org
Fri Dec 6 16:28:44 NZDT 2013
I'm doing a report that looks for patrons in a given branch that have
checked out items after a
specified date. Does this look right?
SELECT count( distinct b.borrowernumber )
FROM borrowers b
JOIN old_issues i USING (borrowernumber)
WHERE b.branchcode = 'WENATCH'
AND i.issuedate > '2012-12-05';
Thank you!
Chad
--
Chad Roseburg
Automation Dept.
North Central Regional Library
More information about the Koha
mailing list