[Koha] Report Help

[Liz Rea]

Give this a try:

SELECT b.title, count(i.itemnumber) AS "number of items", i.itype,
i.ccode FROM biblio b JOIN items i USING(biblionumber) GROUP BY
b.biblionumber

If it works you can add it to the report library. ;)

Cheers,
Liz Rea
Catalyst IT

On 05/04/14 21:31, manoj382093 wrote:
> Dear Friends,
>  I am looking for a report which has list of titles(biblio) their number of
> copies(items) by item type and collection code.
>
>
>
> --
> View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha