[Koha] SQL Report Help

[Nicole Engard]

Thanks!!!! This is just right :)

On Wed, Aug 12, 2009 at 8:36 AM, Bernardo Gonzalez Kriegel <
gonzalez at 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;
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090812/b268ba1e/attachment.htm