[Koha] SQL statement

[Rachel Hollis]

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:nengard at gmail.com]
Sent: Tuesday, March 13, 2012 2:15 PM
To: Rachel Hollis
Cc: koha at lists.katipo.co.nz
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.