On 10 April 2012 09:42, Lenora Oftedahl <oftl at critfc.org> wrote: > As far as I can tell, they aren't even biblios anymore. Is there some way to find items that are not attached to biblios? > Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber FROM biblio) Chris