Have you tried <> instead of =<br clear="all">Susan Bennett<br>ILS System Administrator<br>Geauga County Public Library<br>440 286-6811 x 125<br>440 286-7419 FAX<br>
<br><br><div class="gmail_quote">2009/10/9 Banks, Joy M <span dir="ltr"><<a href="mailto:jbanks@flsouthern.edu">jbanks@flsouthern.edu</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal">Hi everyone-</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">TIA</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">~Joy</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Joy M. Banks</p>
<p class="MsoNormal">Catalog Librarian</p>
<p class="MsoNormal">Roux Library</p>
<p class="MsoNormal">Florida Southern College</p>
<p class="MsoNormal">111 Lake Hollingsworth Dr.</p>
<p class="MsoNormal">Lakeland, FL 33801</p>
<p class="MsoNormal">(863)680-4736</p>
<p class="MsoNormal"><a href="mailto:jbanks@flsouthern.edu" target="_blank">jbanks@flsouthern.edu</a></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>
</div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>