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@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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha