Hi Nicole, See if this works. Garry ________________________ 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 2009/8/12 Nicole Engard <nengard@gmail.com>:
I'm trying to write a report that shows all patrons who have items due tomorrow. I'm probably missing one step in this report, I don't get an error, but I also don't get any results - ideas?
SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,issues.due_date,items.barcode,biblio.title,biblio.author FROM borrowers LEFT JOIN issues on (issues.borrowernumber=borrowers.borrowernumber) LEFT JOIN on items (issues.itemnumber=items.itemnumber) LEFT JOIN on biblio (biblio.biblionumber=items.biblionumber) WHERE issues.date_due = DATE_ADD(curdate()+1 DAYS) ORDER BY borrowers.surname asc
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha