* Report edited so that it now works :-)
Non Circulating Items
Developer: Nicole C. Engard, ByWater Solutions
Module: Circulation
Purpose: List items that have never circulated
Status: Complete
SELECT b.title, b.author, i.barcode, i.itemcallnumber
FROM items i
LEFT JOIN biblio b USING (biblionumber)
WHERE i.itemnumber NOT IN (SELECT itemnumber FROM issues WHERE
itemnumber IS NOT NULL)
AND i.itemnumber NOT IN (SELECT itemnumber FROM
old_issues WHERE itemnumber IS NOT NULL)
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
