SOS Query Wiki: Charges By Sort Code

Revision [384]

Last edited on 2010-01-15 16:52:35 by SethKrieger

Additions:

SUM(a.chgsplamt) as Charges

Deletions:

~~SUM(a.amount) as Charges~~

Revision [103]

Edited on 2008-10-26 16:49:52 by admin

Additions:

----
CategoryQueries

Revision [93]

Edited on 2008-10-26 16:14:27 by admin

Additions:

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

Deletions:

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

Revision [45]

Edited on 2008-10-24 12:33:34 by admin

Additions:

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

Deletions:

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

Revision [44]

Edited on 2008-10-24 12:31:21 by admin

Additions:

Back to [[QueryDirectory Query Directory]]

Deletions:

~~Back to [[QueryDirectory Query Directory]]~~

Revision [43]

Edited on 2008-10-24 12:26:28 by admin

Additions:

======Charges By Sort Code====
Back to [[QueryDirectory Query Directory]]

Deletions:

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

Revision [42]

The oldest known version of this page was created on 2008-10-24 12:21:50 by admin