Hi Beda, Here is a SQL statement (for reports) for obtaining null item types (I think that's what your looking for) I additionally added barcode to the original SQL to make differing copies easier. SQL: SELECT items.barcode,items.dateaccessioned,items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype IS NULL AND items.homebranch='SB' You will also have to change the Homebranch Field to what ever Homebranch code you use. Also if this doesn't work take a look at http://wiki.koha-community.org/wiki/SQL_Reports_Library thats where all the community developed SQL reports are. Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107 ________________________________________ From: koha-bounces@lists.katipo.co.nz [koha-bounces@lists.katipo.co.nz] On Behalf Of Beda Szukics [beda@muri-gries.ch] Sent: Saturday, January 08, 2011 12:28 AM To: koha@lists.katipo.co.nz Subject: [Koha] Finding biblios with no items Hi Is there a way to find biblios with _no_ items attached? Beda _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha