Ciao, Andrea.
Maybe

SELECT DISTINCT(biblionumber), count(biblionumber)
FROM items 
GROUP BY biblionumber
HAVING count(biblionumber) > 1

can help you.
sb

> I'd need to write a report for finding records with multiple items in
> them: any suggestions?
> TIA
> 
> Andrea Furin
_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to