[Koha] Help with sql statement.
nengard at gmail.com
Tue Jun 12 23:29:18 NZST 2012
There were all kinds of problems with that edited report - here's the
one that worked:
SELECT branchcode, categorycode, COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <<Date between (yyyy-mm-dd)>>
AND <<and (yyyy-mm-dd)>> and branchcode = <<Branch|branches>>
GROUP BY branchcode, categorycode ORDER BY branchcode
Field names got a bit messed up and extra 'ands' and characters were wrong.
More information about the Koha