======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