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) _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
