[Koha] SQL statement

[Rachel Hollis]

Greetings friends, I have two SQL statements that I would like to combine but I don't know SQL well enough to do it myself. Could someone help me?

I want to get a list of titles (245a and 245b), authors, and call number along with home-branch and library location.
Below is what I have, probably from the wiki:
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)

And from another report:
WHERE items.homebranch=<<homebranch|branches>> AND items.location='LIB'

Copy and paste didn't work for me. ;-)

Rachel Hollis, librarian
Stevens-Henager College, Boise & Nampa Idaho

________________________________

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.