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 <kgunv...@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 > > kgunv...@fhcrc.org > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha