This should work - in theory : WHERE items.itype=’LKBK’ AND items.ccode NOT LIKE ’LKIX’. 2009/10/9 Banks, Joy M <jbanks@flsouthern.edu>:
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?
TIA
~Joy
Joy M. Banks
Catalog Librarian
Roux Library
Florida Southern College
111 Lake Hollingsworth Dr.
Lakeland, FL 33801
(863)680-4736
jbanks@flsouthern.edu
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha