SELECT
b.lucode as Code,
b.remark as Description,
SUM(a.amount) as Charges 
FROM
rv_charges a JOIN lookups b ON a.sortcode=b.lunum
WHERE
trandate between '1999-01-01' and TODAY()
GROUP BY b.lucode,b.remark