From: Gpc-dev [gpc-dev-boun...@listserv.kumc.edu] on behalf of Kowalski, George
[gkowal...@mcw.edu]
Sent: Wednesday, May 24, 2017 5:00 PM
To: gpc-dev@listserv.kumc.edu
Subject: combining notes
All ,
Per yesterday’s call: Not much to the code to combine text notes . Our main
query is
All ,
Per yesterday’s call: Not much to the code to combine text notes . Our main
query is :
SELECT
pm.date_off,
hnt.*
FROM
hno_note_text hnt
LEFT OUTER JOIN
patient_mapping pm
ON
hnt.pat_id = pm.pat_id
WHERE
hnt.note_id IS NOT NULL
AND hnt.pat_id IS NOT NULL
ORDER BY