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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
