[Koha] Excluding a ccode in a report

Banks, Joy M jbanks at flsouthern.edu
Sat Oct 10 02:21:55 NZDT 2009

Hi everyone-

I'm wanting to run a report for a particular itype in our collection but exclude a certain ccode that exists within the itype. So, I want a report WHERE items.itype='LKBK' but not items.ccode='LKIX'. I've tried a few different ways to express the "not" part, but nothing I tried worked. Could anyone tell me the correct SQL wording to do this?



Joy M. Banks
Catalog Librarian
Roux Library
Florida Southern College
111 Lake Hollingsworth Dr.
Lakeland, FL 33801
jbanks at flsouthern.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091009/f8c3bcb3/attachment-0001.htm 

More information about the Koha mailing list