[Koha] Excluding a ccode in a report

[Susan Bennett]

Have you tried <> instead of =
Susan Bennett
ILS System Administrator
Geauga County Public Library
440 286-6811 x 125
440 286-7419 FAX


2009/10/9 Banks, Joy M <jbanks at 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 at flsouthern.edu
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091009/56041598/attachment.htm