Notifications
Clear all
Topic starter
Ok all you SQL scripting experts this novice needs some help.
I am trying to find all patients that have a HDID = 93634 and = 345865.
I can do one or the other but can't seem to figure out how to do both. This is from the OBS table.
Thanks,
Cecil
Posted : June 18, 2015 10:15 am
This one is for if they have had either or::::
SELECT *
FROM PatientProfile
WHERE (SELECT COUNT(*) FROM OBS WHERE HDID IN (93634, 345865) AND PID = PatientProfile.PID AND CHANGE IN (0,2)) > 0 AND PSTATUS = 'A'
This one is if they have had both:::
SELECT *
FROM PatientProfile
WHERE (SELECT COUNT(*) FROM OBS WHERE HDID = 93634 AND PID = PatientProfile.PID AND CHANGE IN (0,2)) > 0 AND
(SELECT COUNT(*) FROM OBS WHERE HDID = 345865 AND PID = PatientProfile.PID AND CHANGE IN (0,2)) > 0 AND PSTATUS = 'A'
Posted : June 18, 2015 10:23 am
Topic starter
thanks, I new someone would have the answer..
Posted : June 18, 2015 10:53 am
no problem, anytime. 🙂
Posted : June 19, 2015 3:06 am
