[Koha] A report for finding records with multiple items?

[SATISH]

Hi Andrea,

Hope, this will help you.

-----------------------------------------------------------------------------------------------------------------
Developer:  Heather Braum - hbraum at 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 at slacky.it <
andrea.furin at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



--