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>
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
participants (2)
-
Owen Leonard -
Paul A