Katy, There are many ways to show this, do you just want the titles? Do you want call numbers? Here's a list of patrons and checked out items: SELECT issues, biblio.title, author, surname, firstname, items.itemcallnumber, items.barcode, issues.issuedate, issues.lastreneweddate FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber ORDER BY issues.branchcode, borrowers.sort1, borrowers.surname, issues.issuedate, biblio.title Or you can do this to get titles and call numbers of all items checked out (in no order): select biblio.title, items.itemcallnumber from issues left join items on (items.itemnumber=issues.itemnumber) left join biblio on (biblio.biblionumber=items.biblionumber) If you're more specific I can get you just the right report Thanks Nicole C. Engard, ByWater Solutions 2011/4/1 Gunville, Katy <kgunvill@fhcrc.org>:
Hello!
We are new to KOHA. Can anybody help us to run a basic list of all books currently checked out? This should be a simple report and we are having a hard time with it.
Thanks!
Katy Gunville
Arnold Library
Fred Hutchinson Cancer Research Center
1100 Fairview Avenue North, B1-010
P.O. Box 19024
Seattle, WA 98109-1024
Library (206) 667-4314
Direct (206) 667-5017
kgunvill@fhcrc.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha