<html>
<body>
<font size=3>Ian-<br><br>
Here's what we used for a consortia that was looking at about a year back
for use. You might be able to take the parts you need!<br><br>
SELECT i.branchcode AS Library, count(DISTINCT i.borrowernumber) AS
Active_Patrons<br>
FROM issues i<br>
WHERE i.issuedate>='2008-11-01'<br>
GROUP BY i.branchcode<br>
UNION<br>
SELECT o.branchcode AS Library, count(DISTINCT o.borrowernumber) AS
Active_Patrons<br>
FROM old_issues o<br>
WHERE o.issuedate>='2008-11-01'<br>
GROUP BY o.branchcode<br><br>
Kathy<br><br>
At 06:11 PM 1/7/2010, Ian Trim wrote:<br>
<blockquote type=cite class=cite cite="">Hi all What SQL queries are
people using to get 'borrowers who have used their card in the last 2
years'? I have looked in the SQL library... Thanks 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
<a href="http://smx.co.nz/" eudora="autourl">http://smx.co.nz</a>
______________________________________________________________________________
_______________________________________________ Koha mailing list
Koha@lists.katipo.co.nz
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" eudora="autourl">
http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</font></blockquote></body>
<br>
<body>
<font face="Garamond" size=4>Kathleen D. Rippel<br>
Dept. Head/Consultant--Resource Sharing and Access ; <br>
Pathfinder Central (Manager)<br>
Central Kansas Library System<br>
1409 Williams<br>
Great Bend, KS 67530<br><br>
(620-792-4865) phone<br>
(800-362-2642) toll-free, KS<br>
(620-792-5495) fax<br><br>
kdr@ckls.org<br>
</font><font size=3>
********************************************************************************************<br>
</font><font face="Garamond" size=4>I'm currently reading: World War II
Military Records: a family historian's guide, by Debra Johnson Knox.<br>
I'm currently listening to: Between Sundays, by Karen
Kingsbury.</font></body>
</html>