Re: [Koha] Collection Code Totals

20 Nov 2013

      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.