[Koha] looking for report help
nengard at gmail.com
Tue Aug 13 07:06:41 NZST 2013
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.
More information about the Koha