Hi I would like to add the following fields to sql query after OnlineURL
koha 19.05 1. 8 - Collection code 2.c - Shelving location SELECT items.Barcode,biblio.Author,biblio.Title AS Titles,biblioitems.Pages,biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.publishercode AS Publisher,biblioitems.Place,biblio.unititle AS Subject,items.location AS Department,biblioitems.itemtype AS Department,items.itype AS Status,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes,biblio.Serial,items.Issues,items.Renewals FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD(items.barcode,40,' ') ASC please help me -- Y.Yatheesh Babu 8247838231 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
