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

2010/2/1 Ian Trim <ian.trim@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