> Simplistic, but functional: > > SELECT biblio.biblionumber AS BibNum, biblio.title AS Title, biblio.author > AS Author, items.barcode AS Barcode > FROM biblio > RIGHT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber > LEFT JOIN items ON biblio.biblionumber=items.biblionumber > WHERE items.biblionumber IS NULL
An alternative is in the SQL Reports Library on the wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_without_items I don't know if one is better than the other, I just wanted to point out the wiki as the first place to check when looking for reports. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
