If you don't mind, put your two pieces in to my report in the right places - my problem is that I'm not sure the Join goes where I would normally put it.
Nicole On Thu, Jul 28, 2011 at 12:45 PM, Grobani, Daniel <dgrob...@samuelmerritt.edu> wrote: > How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = > items.biblioitemnumber)? > > Daniel > > -----Original Message----- > From: Nicole Engard [mailto:neng...@gmail.com] > Sent: Thursday, July 28, 2011 4:36 AM > To: Grobani, Daniel > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Report Help - Extracting XML > > Daniel, > > That part I knew :) it was getting it in to the query (the joining) I was > having trouble with :) > > Nicole > > On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani <dgrob...@samuelmerritt.edu> > wrote: >> Nicole, >> >> This should give you the 520a: >> >> extractValue(biblioitems.marcxml, >> "collection/record/datafield[@tag='520'][1]/subfield[@code='a']") >> >> Of course, you'll have to do a join on biblioitems. >> >> >> ----- >> Cheers, >> Daniel Grobani >> Library Technology Specialist >> John A. Graziano Memorial Library >> Samuel Merritt University >> >> -- >> View this message in context: >> http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604 >> p4640701.html Sent from the Koha - Discuss mailing list archive at >> Nabble.com. >> _______________________________________________ >> 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