select distinct pt.person_id, p.last_name, p.first_name, p.address_line_1, p.city, p.state, p.zip from patient_ pt INNER JOIN vital_signs_ vs ON vs.person_id = pt.person_id INNER JOIN patient_problems pp ON pp.person_id = pt.person_id INNER JOIN lab_results_obx lr ON lr.person_id = pt.person_id INNER JOIN person p on p.person_id = pt.person_id where pt.age >= 18 AND vs.BMI_calc >= 22 and ((lr.obs_id like '25000000^GLUCOSE^' and CAST(lr.observ_value AS decimal)>100) OR (lr.obs_id like '%FM HEM A1C^HEMOGLOBIN A1C^I%') and NOT EXISTS (select NULL from patient_problems p1 where ( description like 'Diabetes%') AND pt.person_id = p1.person_id)) order by p.last_name desc
and NOT EXISTS (select NULL from patient_problems p1 where ( description like 'Diabetes%') AND pt.person_id = p1.person_id))
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.