Charges By Sort Code

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