12 Aug
2013
12 Aug
'13
8:06 p.m.
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