Thanks Nicole, that worked perfectly.
Chad
On Fri, Dec 6, 2013 at 6:44 AM, Nicole Engard wrote:
>
> On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg wrote:
>
>> SELECT count( distinct b.borrowernumber )
>> FROM borrowers b
>> JOIN old_issues i USING (borrowernumber)
>> WHERE b.branchcode = 'WENA
On Thu, Dec 5, 2013 at 9:28 PM, Chad Roseburg 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
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';
3 matches
Mail list logo
