2 Sep
2011
2 Sep
'11
1:57 a.m.
2011/9/2 Hal Bright <HBright@farmingtonlibraries.org>:
I want a list of books in a particular Item Type that are only checked in. Is there a code like items.status 'checkedin'? for the item?
Nope, but there is a checked out one, called onloan, if that is null or blank the book is checked in SELECT title,author,barcode FROM biblio,items WHERE biblio.biblionumber=items.biblionumber AND items.itype ='you item type goes here' AND (items.onloan is NULL or items.onloan = '') Thats two ' not one " :) Chris