[Koha] need help with report

[Nicole Engard]

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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>