[Koha] SQL statement for generating current checkouts

[nabonita Guha]

Dear Koha users/Developers,

Can you please help me in building SQL statement to generate current
checkouts on a given date (not for a date range). For example, I need to
generate a report to get list of (barcodes with borrowers card number,
surname and firstname and borrower's category with date of issue) were on
Loan as on 2011-03-29.

Looking forward to hearing from you.

With best 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110420/334d1ff5/attachment.htm