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