Hi David, What about this one:
SELECT items.itemcallnumber,biblio.title,biblio.author,items.barcode,items.price,items.replacementprice FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC Hope this helps. Irma CALYX On 20 July 2016 at 11:25, Decka David <dda...@lib.unitech.ac.pg> wrote: > Dear Koha Community, > > Please can someone help to provide insight into creating shelf list report > that includes the following; > > 1. Call Number > 2. Title > 3. Author > 4. Barcode and > 5. Cost > > This sort of information and report can help our library into doing simple > stock-take for the total records after migration. > > Thank you > > Decka David > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
