Thanks!!!! This is just right :)<br><br><div class="gmail_quote">On Wed, Aug 12, 2009 at 8:36 AM, Bernardo Gonzalez Kriegel <span dir="ltr"><<a href="mailto:gonzalez@famaf.unc.edu.ar">gonzalez@famaf.unc.edu.ar</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;"><div id=":1tq" class="ii gt">SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,issues.date_due,items.barcode,biblio.title,biblio.author FROM borrowers LEFT JOIN issues ON (issues.borrowernumber=borrowers.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber) WHERE issues.date_due = DATE_ADD(curdate(), INTERVAL 1 DAY) ORDER BY borrowers.surname asc;</div>
</blockquote></div><br>