This is what we use:<br><br>SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.phone,borrowers.branchcode,borrowers.categorycode,borrowers.address,borrowers.address2,borrowers.city,borrowers.zipcode, items.homebranch, items.holdingbranch,items.itemcallnumber, items.location, items.ccode,issues.date_due,biblio.author,biblio.title,items.barcode,items.replacementprice FROM borrowers LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)<br>
WHERE issues.date_due < DATE_SUB(now(), INTERVAL <i>put in the number of days overdue you are checking for</i> DAY) AND issues.returndate IS NULL ORDER BY borrowers.surname asc<br><br>This has more fields then you need but it's easy to take the un-needed ones out. Hope this helps!<br>
<br clear="all">Susan Bennett<br>ILS System Administrator<br>Geauga County Public Library<br>440 286-6811 x 125<br>440 286-7419 FAX<br>
<br><br><div class="gmail_quote">On Wed, Oct 7, 2009 at 3:54 AM, ahtshun83 <span dir="ltr"><<a href="mailto:tony_ykt@yahoo.com">tony_ykt@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Hi all,<br>
<br>
I would like to extract out a list of patrons who has overdue books which<br>
has yet to return. I need the required field such as surname,card<br>
number,book borrowed & due date.<br>
<br>
is there anyone has a sample of the above script?<br>
<br>
appreciated and thank you in advanced<br>
<font color="#888888">--<br>
View this message in context: <a href="http://www.nabble.com/Koha-MySQL-Statement-tp25782087p25782087.html" target="_blank">http://www.nabble.com/Koha-MySQL-Statement-tp25782087p25782087.html</a><br>
Sent from the Koha - Discuss mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
Koha mailing list<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>
</font></blockquote></div><br>