[Koha] Reporting biblios with no items
Beda Szukics
beda at kollegium-sarnen.ch
Thu Feb 11 02:20:31 NZDT 2016
Hello
The following report:
SELECT biblio.biblionumber, biblio.title
FROM biblio
LEFT JOIN items ON biblio.biblionumber = items.biblionumber
WHERE items.itemnumber IS NULL
shows all the biblios with no item. Is there a possibility to expand it
so it doesn't show all the _analytic_ records (Sadly those show up too
and I want to have a list with all the records witch have no holding
information at all).
Beda
More information about the Koha
mailing list