At 05:35 PM 6/9/2012 -0700, James Ghiorzi wrote:
Hi Jared,
Thanks for responding on a weekend :). I changed the statement to:
SELECT b.code,c.code,COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <<Date between
(yyyy-mm-dd)>>
AND DATE(dateenrolled) <<and (yyyy-mm-dd)>> and b.code<<Pick your
branch|branches>>
GROUP BY c.code
but its still not producing any data, I am thinking that I am missing
something else maybe a left/right join on something.
Maybe teaching grandmother to suck eggs, but you are putting a semi-colon
at the end?
Best - Paul
Orginal SQL by Sharon :
SELECT branchcode,categorycode,COUNT(*)
FROM borrowers WHERE MONTH(dateenrolled) = <<Month enrolled (mm)>> AND
YEAR(dateenrolled)= <<Year enrolled (yyyy)>>
GROUP BY branchcode,categorycode
ORDER BY branchcode
Please advise,
James Ghiorzi
Data Management Coordinator
Martin Luther King Jr. Library
San Jose State University
________________________________
From: Jared Camins-Esakov [jcam...@cpbibliography.com]
Sent: Saturday, June 09, 2012 4:55 PM
To: James Ghiorzi
Cc: koha@lists.katipo.co.nz; neng...@bywatersolutions.com
Subject: Re: [Koha] Help with sql statement.
James,
I am trying to get the new patron report developed by Sharon Moreland, to
do a date range and have a location selection for San Benito County Free
Library. I am sure I am doing something wrong, please advise as necessary,
SQL:
SELECT b.code,c.code,COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <<Date
between (yyyy-mm-dd)>> AND DATE(dateenrolled)= <<and (yyyy-mm-dd)>> and
b.code=<<Pick your branch|branches>>
GROUP BY c.code
You have an extra = after the second DATE(dateenrolled)
Regards,
Jared
--
Jared Camins-Esakov
Bibliographer, C & P Bibliography Services, LLC
(phone) +1 (917) 727-3445
(e-mail) jcam...@cpbibliography.com<mailto:jcam...@cpbibliography.com>
(web) http://www.cpbibliography.com/
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
