Forgot to hit reply to all! This will do what you want (I think):
select p.surname, p.firstname, p.cardnumber, p.dateexpiry, count(c.itemnumber) as 'items out' from borrowers p left join issues c using (borrowernumber) where p.dateexpiry < now() and p.borrowernumber in (select borrowernumber from issues) group by p.borrowernumber Thanks On Mon, Aug 27, 2012 at 10:23 AM, Hartman, David W. - GBTS Library <david.w.hart...@disney.com> wrote: > Hello! > > Is there a report in Koha to notify the librarian about the expired patrons > who still have items checked out? I did not see one but I'd like to see a > report of the expired patrons who have not returned their items.] > > David > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
