Report: patrons with recent checkouts
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
On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg <croseburg@ncrl.org> wrote:
SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN old_issues i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate > '2012-12-05';
Yes, but it won't include people with things currently checked out - those people are still in the issues table. So you might want (and this will slow it down a bit) to query that table too: SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN (select borrowernumber, issuedate from old_issues union all select borrowernumber, issuedate from issues) i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate > '2012-12-05';
Thanks Nicole, that worked perfectly. Chad On Fri, Dec 6, 2013 at 6:44 AM, Nicole Engard <nengard@gmail.com> wrote:
On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg <croseburg@ncrl.org> wrote:
SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN old_issues i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate > '2012-12-05';
Yes, but it won't include people with things currently checked out - those people are still in the issues table. So you might want (and this will slow it down a bit) to query that table too:
SELECT count( distinct b.borrowernumber ) FROM borrowers b JOIN (select borrowernumber, issuedate from old_issues union all select borrowernumber, issuedate from issues) i USING (borrowernumber) WHERE b.branchcode = 'WENATCH' AND i.issuedate > '2012-12-05';
-- Chad Roseburg Automation Dept. North Central Regional Library
participants (2)
-
Chad Roseburg -
Nicole Engard