7 Nov
2013
7 Nov
'13
12:48 p.m.
At 05:57 AM 11/7/2013 -0500, Leslie A. Markey wrote:
Hello Koha Community,
Does anyone have a report that gives a list of bib records (by title) that have no item records?
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 Best - Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>