Hi Andrea, Hope, this will help you.
----------------------------------------------------------------------------------------------------------------- Developer: Heather Braum - hbr...@nekls.org ----------------------------------------------------------------------------------------------------------------- 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, andrea.fu...@slacky.it < andrea.fu...@slacky.it> 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 > 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
