This simplification should do the trick: SELECT borrowers.surname,borrowers.firstname,borrowers.cardnumber,borrowers.categorycode FROM borrowers WHERE borrowers.categorycode='1ST' ORDER BY borrowers.surname,borrowers.firstname Thanks Nicole C. Engard 2011/3/8 <ksckemperman@chartermi.net>:
We've just had our first week checking out books with Koha and it went very well - woohoo! I have a report to list the students in each class. I noticed that after the first week of checkouts, the report is listing the name of each student that checked out a book twice, even after the book is checked in. To clarify, this report is just a list of each student in each class, not anything about books checked out, etc. I can't figure out what to edit in the SQL so that I get just one line per student - any ideas? This is the SQL for the 1st grade list:
SELECT borrowers.surname,borrowers.firstname,borrowers.cardnumber,borrowers.categorycode FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) WHERE borrowers.categorycode='1ST' ORDER BY borrowers.surname,borrowers.firstname Thanks, Shelley _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha