======Charges By Sort Code======

Back to [[QueryDirectory Query Directory]]


%%(sql)
SELECT
b.lucode as Code,
b.remark as Description,
SUM(a.chgsplamt) 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%%

----
CategoryQueries