Dear Vimal / All Please check the SQL below for your required output. SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers, items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch =<<Branch|branches>> AND items.barcode BETWEEN <<From Acc>> AND <<To Acc)>> ORDER BY LPAD(items.barcode,30,' ') ASC Regards, *Ata ur Rehman** Manager**, Library - NCP* Tel: (+92-51) 2077-347 | Mobile: (+92-321) 946-2931 www.ncp.edu.pk On Thu, Oct 18, 2012 at 12:31 AM, Vimal Kumar V. <vimal0212@gmail.com>wrote:
Dear Friends,
How can we create a book list between range of accession numbers (100-200). It should list books with accession number between 100 to 200.
Regards,
-- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha