7 Apr
2014
7 Apr
'14
2:08 a.m.
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