[Koha] reports -

[Jonson philip]

hi
i'm trying to create report to explain paid fines and duration between
duedate and returndate but when i'm running this

SELECT borrowers.firstname, borrowers.surname, accountlines.amount,
accountlines.accounttype, borrowers.cardnumber, accountlines.`date` ,
old_issues.date_due, old_issues.returndate, old_issues.itemnumber
FROM borrowers
INNER JOIN accountlines ON ( borrowers.borrowernumber =
accountlines.borrowernumber )
INNER JOIN old_issues ON ( accountlines.borrowernumber =
old_issues.borrowernumber )
WHERE (
accountlines.accounttype > -1
)
AND (
MONTH( date ) = MONTH( NOW( ) )
)
AND (
accounttype LIKE 'Pay'
)
AND (
old_issues.date_due < old_issues.returndate
)
LIMIT 0 , 30

i getting results not correct , any one can help to create this report
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110420/fb9b35ec/attachment-0001.htm