On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg <croseb...@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'; _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha