On 21 February 2012 10:17, Paul <pau...@aandc.org> wrote: > Help requested please from an expert in MySQL reports. The code below works > perfectly, but I want to add 952$x (a text string for the condition of our > holdings as in "good/fair" or "fine tpb") to the first line. > > If I add items.more_subfields_xml (which includes 952$x) I get a plethora of > formatted XML that is unsuitable for copying straight into a spreadsheet. > > I have tried "mapping" 952$x to "condition" -- but have failed to create an > "items.condition" -- is there another "name of field" that I can use? > > SELECT items.biblionumber,items.barcode,items.dateaccessioned > > FROM items > LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) > > ORDER BY items.biblionumber asc >
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC Chris > Many thanks - Paul > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
