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