Query L Pharm total

Revision as of 15:28, 16 April 2015 by Ttenbergen (talk | contribs) (Created page with "Lines in this table L Pharm Flowsheet give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmac...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Lines in this table L Pharm Flowsheet give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmacy for a patient see query L_Pharm_total.

This query eliminates the entry_date field, groups by D_ID, and sums all other fields.