<font face="arial">Dear Friends,<br>I could generate the current checkouts with following SQL query:<br><br>SELECT issues.issuedate,items.barcode,biblio.title, author,borrowers.firstname,borrowers.surname 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 ORDER BY issues.issuedate<br>
<br>Please help me to generate the same as per date limit. For example:
I need to generate report of current checkouts as of 29th March 2011.
How shall I modify the query so that I can get the report limited with
date.<br><br>With best regards<br></font><br clear="all"><br>-- <br>Vimal Kumar V.<br>Mahatma Gandhi University Library<br>Kottayam, Kerala- 686 560<br>Web: <a href="http://www.vimalkumar.co.nr" target="_blank">http://www.vimalkumar.co.nr</a><br>
Blog: <a href="http://vimalkumar.oksociety.in" target="_blank">http://vimalkumar.oksociety.in</a> <a href="http://linuxhalwa.blogspot.com" target="_blank">http://linuxhalwa.blogspot.com</a><br>---------------------------------------------------------------------------<br>
"I forget what I was taught. I only remember what I have learnt"<br>-Patrick White<br>