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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
