Hi Kerrie, Try adding on a GROUP BY ccode, as follows: SELECT count(ccode), ccode AS collection FROM items WHERE homebranch = 'VIC' GROUP BY ccode;
Cheers, Liz Rea Catalyst IT Ltd. _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
