[Koha] Report_Circulation (Jameela)

Jameela P jameelaforu at gmail.com
Sat Nov 15 22:53:24 NZDT 2014


 I got the desired  results. Thank to one and all who've guided me. I
posting the SQL code below. Thanks once again

SELECT
borrowers.cardnumber,borrowers.surname,items.barcode,items.price,items.booksellerid,items.homebranch,items.itemcallnumber,items.holdingbranch,items.cn_source,biblioitems.pages,biblioitems.notes,biblioitems.publishercode,biblioitems.publicationyear,biblioitems.place,biblioitems.isbn,biblio.title,biblio.author
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) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber)


More information about the Koha mailing list