Revision [98]

Last edited on 2008-10-26 16:47:29 by admin
Additions:
----
CategoryQueries

Revision [86]

Edited on 2008-10-26 16:08:05 by admin
Additions:
%%(sql)

Revision [74]

Edited on 2008-10-24 16:57:30 by admin
Additions:
======Query Title ======
//
comments here appear in italics
//
%%
paste your tested query here
%%
Deletions:
======Active Patient Balances Sorted by Primary Provider======
//Our practice has 40+ therapists and we would like to be able to give them a simple monthly report showing account balances due by patients. //
%%SELECT
prv.provcode AS "primary provider", pt.lastname, pt.firstname, pt.id, bal.ptbalance
FROM
patients pt
JOIN providers prv ON pt.providernum = prv.providernum
JOIN PT_NONINSBALANCE bal ON pt.ptnum = bal.ptnum
WHERE
pt.flag = 0
AND pt.dischargedate IS NULL
AND pt.licnum = 101
ORDER BY "primary provider"%%

Revision [73]

The oldest known version of this page was created on 2008-10-24 16:55:46 by admin [Cloned from ActivePatientBalancesSortedByPrimaryProvider]
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki