Charges by Sort Code

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