[Koha] Koha report

[Owen Leonard]

> 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_items

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