[solved!] A Database Error Occurred

[eluser]maria clara[/eluser]
hi,
i encounter this error when im trying to add a new data in my jqgrid. the data was shown but it shows this in my console.

Code:

Error Number: 1064</p><p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return) as `return`
FROM (`erp_ar_sales`)
WHERE `client_id` IS NULL
AND `status`' at line 1</p><p>SELECT SUM(gross) as sales, SUM(paid) as payment, SUM(credit) as credit, SUM(debit) as debit, SUM(return) as `return`
FROM (`erp_ar_sales`)
WHERE `client_id` IS NULL
AND `status` != '2'
AND `is_deleted` = '0'</p>

hope someone can help me..


thanks in advance,
maria