On Mon, Mar 31, 2014 at 11:33 AM, Katelyn Browne <kbro...@ccpcs.org> wrote: > SELECT borrowernumber, GROUP_CONCAT(items.itemcallnumber, " ( ", > biblio.title, ") ") AS booklist > FROM (SELECT borrowernumber > FROM statistics > WHERE date(statistics.datetime) BETWEEN <<Returned between (YYYY-MM-DD)>> > AND <<and (YYYY-MM-DD)>> > AND statistics.type='return' > GROUP BY borrowernumber) whoreturned > LEFT JOIN issues USING (borrowernumber) > LEFT JOIN items USING (itemnumber) > LEFT JOIN biblio USING (biblionumber) > WHERE date(issues.date_due) BETWEEN <<Due between (YYYY-MM-DD)>> AND <<and > (YYYY-MM-DD)>> > GROUP BY borrowernumber
Thanks!! I'll give it a whirl. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha