21 May
2013
21 May
'13
3:51 p.m.
* 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)