Revision [121]
Last edited on 2008-10-27 11:36:52 by adminAdditions:
flag = 0 /*active patient */
AND dischargedate IS NULL /*no discharge date has been entered */
AND dischargedate IS NULL /*no discharge date has been entered */
Deletions:
AND dischargedate IS NULL //no discharge date has been entered
Revision [97]
Edited on 2008-10-26 16:46:40 by adminAdditions:
----
CategoryQueries
CategoryQueries
Revision [87]
Edited on 2008-10-26 16:08:29 by adminAdditions:
%%(sql)
SELECT
SELECT
Deletions:
Revision [41]
Edited on 2008-10-24 11:42:04 by adminAdditions:
%%SELECT
ORDER BY "Primary Prov", a.lastname, a.firstname, a.id%%
ORDER BY "Primary Prov", a.lastname, a.firstname, a.id%%
Deletions:
ORDER BY "Primary Prov", a.lastname, a.firstname, a.id##
Revision [35]
Edited on 2008-10-24 11:01:29 by adminAdditions:
Back to [[QueryDirectory Query Directory]]