Credits Without Sort Codes By Primary Provider
Back to Query Directory
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
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
CategoryQueries