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>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
