[Koha] looking for report help

[Heather Braum (NEKLS)]

Nicole, It looks like that works on our system! That will be a really
useful report. Thanks!

Heather Braum
Digital and Technical Services Librarian
Northeast Kansas Library System
hbraum at nekls.org

"The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*





On Mon, Aug 12, 2013 at 2:06 PM, Nicole Engard <nengard at gmail.com> wrote:

> I think I might have figured this out with some brainstorming ...
> anyone see why this wouldn't work?
>
> select b.title, b.biblionumber, count(distinct itype) as types from
> biblio b left join items i using (biblionumber) group by
> i.biblionumber having count(distinct itype) > 1
>
> On Fri, Aug 9, 2013 at 9:12 AM, Nicole Engard <nengard at gmail.com> wrote:
> > I'm wondering if there is a way to find bibs that have multiple items
> > attached where the items are not all of the same type? I think there
> > are some nested queries involved in this - but I'm not really sure
> > where to start.
> >
> > Thanks
> > Nicole
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>