<font size="2"><font face="verdana,sans-serif">Nabonita,<br><br>You can use this query if you want to see the title:<br><br>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 = 'yyyy-mm-dd'<br>
<br>If you don't need the title, use this query:<br><br>SELECT issues.issuedate, items.barcode, 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 WHERE issues.issuedate = 'yyyy-mm-dd'<br clear="all">
</font></font><br><br><br>* * * * <br>Beverly Church <br>LibLime Project Manager<br><br>phone: 1-888-564-2457 ext. 717 <br> 1-301-654-8088 ext. 292<br>email: <a href="mailto:bchurch@liblime.com" target="_blank">bchurch@liblime.com</a><br>
skype: beverlychurch<br>
<br><br><div class="gmail_quote">2011/4/20 nabonita Guha <span dir="ltr"><<a href="mailto:nabonita@jncasr.ac.in">nabonita@jncasr.ac.in</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<font face="arial">Dear Koha users/Developers,<br><br>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.<br><br>Looking forward to hearing from you.<br><br>With best regards<br><br><div>Nabonita<br>
<br>
--<br>
Nabonita Guha<br>
Library-cum-Information Officer<br>
Library, Jawaharlal Nehru Centre <br>
for Advanced Scientific Research,<br>
Jakkur Post, Bangalore 560064<br>
Karnataka, India<br>
Phone: +91-80-22082930<br>
Email: <a href="mailto:nabonita@jncasr.ac.in" target="_blank">nabonita@jncasr.ac.in</a><br>
Web: <a href="http://lib.jncasr.ac.in/" target="_blank">http://lib.jncasr.ac.in</a></div></font>
<br>_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>