Thank you so much, it is just what I was after! I'll be happy to post it to the wiki too. :-)
Rachel Hollis, librarian Stevens-Henager College, Boise & Nampa -----Original Message----- From: Nicole Engard [mailto:[email protected]] Sent: Tuesday, March 13, 2012 2:15 PM To: Rachel Hollis Cc: [email protected] Subject: Re: [Koha] SQL statement That didn't work right! try this instead: SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM biblioitems b2 WHERE b.biblionumber = b2.biblionumber), '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author, i.itemcallnumber FROM biblio b LEFT JOIN items i ON (i.biblionumber=b.biblionumber) where i.homebranch=<<homebranch|branches>> AND i.location='LIB' ________________________________ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
