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 <ddavid@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