[Koha] SQL statement for generating current checkouts

[nabonita at jncasr.ac.in]

Hi Beverly,

Thanks for the SQL statement. This is the output what I was looking
for.

With regards

Nabonita

--
Nabonita Guha
Library-cum-Information Officer
Library, Jawaharlal Nehru Centre 
for Advanced Scientific Research,
Jakkur Post, Bangalore 560064
Karnataka, India
Phone: +91-80-22082930
Email: nabonita at jncasr.ac.in
Web: http://lib.jncasr.ac.in

At Thursday, 21-04-2011 on 5:52 pm Church, Beverly wrote:

Hi Nabonita,

Try this query. It looks for any items that are current checked out
where the checkout date was on or before 2011-03-29, or the last
renewal date was or before 2011-03-29.. 

SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumber,
borrowers.categorycode FROM issues LEFT JOIN borrowers ON
borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON
issues.itemnumber = items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber WHERE issues.issuedate 

Links:
------
[1] http://lib.jncasr.ac.in/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110429/fd0cfa3f/attachment.htm