Hi Andrea, Hope, this will help you.
----------------------------------------------------------------------------------------------------------------- Developer: Heather Braum - [email protected] ----------------------------------------------------------------------------------------------------------------- SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber --------------------------------------------------------------------------------------------------------------------- With Thanks Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. On Fri, Feb 6, 2015 at 1:47 AM, [email protected] < [email protected]> wrote: > Hi. > I'd need to write a report for finding records with multiple items in > them: any suggestions? > TIA > > Andrea Furin > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > -- _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
