Something like this may work: SELECT b.cardnumber, b.surname, b.firstname, i.issuedate FROM borrowers b INNER JOIN issues i ON (b.borrowernumber = i.borrowernumber) WHERE i.issuedate BETWEEN <<Issue Date Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY b.cardnumber
Joe On Wed, Feb 20, 2019 at 11:24 AM Chris Brown <ch...@stayawake.co.uk> wrote: > Gentle Reader, > > We want to get a list of all patrons for who we do *not *have email > addresses but who are "active" (for example, have checked a book out in the > last 6 months) > > I know how to get a list of patrons with no email address but my knowledge > of SQL and the database schema aren't good enough to write the "AND have > checked a book out in the last 6 months" part of the query. > > Is there a kind soul out there who could help? We are using Koha 17.11 > > Thanks and Best Regards, > > Chris Brown > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Joe Sikowitz Collaborative Services Librarian Fenway Library Organization (617) 989-5031 j...@flo.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
