[Koha] SQL Report Help

[Garry Collum]

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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>