How do I add title in the SQL report below to generate circulation statistics by call number? SELECT count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS
'Call Number', (items.barcode) AS 'Accession Number' FROM borrowers LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items ON (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = items.biblioitemnumber) WHERE date(statistics.datetime) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND statistics.branch = <<Branch|branches>> AND items.location = <<Location|loc>> AND statistics.itemtype = <<Item type|itemtypes>> GROUP BY items.itemcallnumber ORDER BY items.itemcallnumber ASC
I tried adding biblio.title in many places but it always ending up in error. I'm not a programmer that is why I'm struggling with this. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892