[Koha] SQL for item held at one or two out of three libraries

[Chris Cormack]

2010/2/1 Ian Trim <ian.trim at kapiticoast.govt.nz>:
> Hi all
>
> We have three libraries. How does one ask for items that are:
> * held at a specific library
> * might be at one other of the three libraries
> * but definitely NOT held at all three libraries
>
> This is for stock rotation work.
>
> Thank you in advance.
>
> ~Perhaps just not held at all three libraries will cut the mustard - as the results will be small enough to eyeball (doing it by ccode and not onloan).
>
Hi Ian

Do you mean biblios that have items at at least one library, but not
all three? IE an item can only be in one place at once so we are
talking about multiple copies of the same title eh?

Chris