Thanks!!!! This is just right :) On Wed, Aug 12, 2009 at 8:36 AM, Bernardo Gonzalez Kriegel < gonzalez@famaf.unc.edu.ar> wrote:

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;