Charges By Sort Code
Back to Query Directory
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
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
