31 Mar
2014
31 Mar
'14
6:59 p.m.
On Mon, Mar 31, 2014 at 11:33 AM, Katelyn Browne <kbrowne@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.