7 Nov
2013
7 Nov
'13
2:55 p.m.
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_ite... 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