I have one ... did I not add it to the wiki? #this report shows the total number of items circulated from a branch other than the owning branch SELECT count(*) as total from statistics LEFT JOIN items on (statistics.itemnumber = items.itemnumber) where statistics.branch != items.homebranch AND statistics.datetime between '2008-01-01' and '2008-12-31' #same except limited by branch SELECT statistics.branch,count(*) as total from statistics LEFT JOIN items on (statistics.itemnumber = items.itemnumber) where statistics.branch != items.homebranch AND statistics.datetime between '2008-01-01' and '2008-12-31' and items.homebranch = 'BRANCH' group by statistics.branch --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Mon, May 4, 2009 at 9:45 AM, <dschust1@tx.rr.com> wrote:
Anybody have an SQL or some type of report that shows how many books were borrowed between locations in a given time period?
I will be adding a few SQL's that I've come up with to the Wiki hopefully today! You all ROCK!
David Schuster _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha