Hi all of you who are more koha report savvy,
I use this report to send out our overdue account letters but would like to add
in the earliest account date to enable me to send out monthly letters.
Please help me.
Accounts with more than
Total number of rows matching the (unlimited) query is 162.
SELECT p.cardnumber, p.surname, p.firstname, p.address, p.address2, p.city,
p.state, p.phone, p.branchcode AS 'patron branch',
p.debarred , p.debarredcomment, p.dateexpiry,
format(sum(a.amountoutstanding),2) AS 'amount owed'
FROM borrowers p
LEFT JOIN accountlines a USING (borrowernumber)
GROUP BY a.borrowernumber
HAVING sum(a.amountoutstanding) >
Tony Morton | Senior Librarian
Waimate District Library
Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New
Zealand
*: +64 3 689 0000 | DDI: +64 3 689 0071 | Ê: +64 3 689 8075 | Mobile: +64
0210740867
*: [email protected]<mailto:[email protected]> | ý
www.waimatedc.govt.nz<http://www.waimatedc.govt.nz/>
______________________________________________________________________________
This email has been scrubbed for your protection by SMX.
For more information visit http://smxemail.com
______________________________________________________________________________
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
