[Koha] Excluding a ccode in a report

[Nicole Engard]

This should work - in theory :

WHERE items.itype=’LKBK’ AND items.ccode NOT LIKE ’LKIX’.

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
>
>