Thanks a bunch! This appears to work. I'll post this to the wiki in your name so that you get credit for the work and so that others can benefit from this.
Nicole 2011/8/17 Msgr. Marion J. Makarewicz <marmak3...@att.net>: > SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, > > i.barcode, i.datelastborrowed, i.issues as totalcheckouts, > > i.dateaccessioned > > FROM items i > > LEFT JOIN issues > > USING (itemnumber) > > LEFT JOIN biblio b > > USING (biblionumber) > > WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND > YEAR(NOW())-YEAR(i.datelastborrowed) > 5 > > UNION SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, > > i.barcode, i.datelastborrowed, i.issues as totalcheckouts, > > i.dateaccessioned > > FROM items i > > LEFT JOIN issues > > USING (itemnumber) > > LEFT JOIN biblio b > > USING (biblionumber) > > WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues) AND > YEAR(NOW())-YEAR(i.datelastborrowed) > 5; _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha