6 Dec
2013
6 Dec
'13
3:44 p.m.
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';