Revision [461]
Last edited on 2011-07-22 14:33:29 by adminAdditions:
======Credits Without Sort Codes By Primary Provider======
We have discovered that some credit entries were entered without specifying a Sort Code, which we need for reporting purposes. I need a total amount of such credits, by provider.
SELECT
p.provcode,
r.provlname,
SUM(amount) AS "TotalCredits"
FROM
journal j,
patients p,
providers r
WHERE
j.ptnum=p.ptnum AND
p.providernum=r.providernum AND
j.trandate BETWEEN '2000-03-01' and '2000-03-15' AND
j.sortcode is null
GROUP BY
patients.provcode, providers.provlname
We have discovered that some credit entries were entered without specifying a Sort Code, which we need for reporting purposes. I need a total amount of such credits, by provider.
SELECT
p.provcode,
r.provlname,
SUM(amount) AS "TotalCredits"
FROM
journal j,
patients p,
providers r
WHERE
j.ptnum=p.ptnum AND
p.providernum=r.providernum AND
j.trandate BETWEEN '2000-03-01' and '2000-03-15' AND
j.sortcode is null
GROUP BY
patients.provcode, providers.provlname
Deletions:
comments here appear in italics
paste your tested query here
