How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = items.biblioitemnumber)?
Daniel -----Original Message----- From: Nicole Engard [mailto:[email protected]] Sent: Thursday, July 28, 2011 4:36 AM To: Grobani, Daniel Cc: [email protected] 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 <[email protected]> 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 [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
