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

[Ian Trim]

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


Ian Trim
Circulation Services Librarian 
Te Kaitiaki Pukapuka Wāhi Tuku
Paraparaumu Library
9 Iver Trask Place 
Paraparaumu
04 2964 797
Skype ian.trim 

Kapiti Coast District Council does not guarantee the accuracy or completeness of any information contained in this e-mail or attached files. Internet communications are not secure; therefore the Council does not accept legal responsibility for the contents of this message or attached files. The content of this email may express the view of the author and not the official position of the Council. Kapiti Coast District Council may monitor and store all outgoing and incoming email traffic. This e-mail is subject to copyright. Except in reply to the author, no part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. If you have received this e-mail in error, please advise the sender immediately by return e-mail, or telephone the author and delete all copies.

#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

______________________________________________________________________________

This email has been scrubbed for your protection by SMX.
For more information visit http://smx.co.nz
______________________________________________________________________________