28 Jan
2010
28 Jan
'10
6:12 p.m.
Koha has a built-in report listing the patrons with the most checkouts for a given time period. However, it only provides a name & the issue count. We would like a report that also provides contact info for the patron -- street & email addresses, phone number, etc. Can someone provide us with a headstart on how to write this SQL statement? I've looked at the table structure for transaction data but can't figure it out. Nothing relevant on the wiki either as far as I can tell. (I think it would be helpful if SQL statements were provided for all of the canned reports, so staff could review these, learn from them, use them as the basis for new reports, etc.) Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH