[Koha] looking for report help

[Nicole Engard]

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