You are here: Home → Information for OSCAR Users → EMR Resources → QBE → Select patients with HbA1C > 0.07
Personal tools
Search Site

 
Document Actions

Select patients with HbA1C > 0.07

by David Chan — last modified 2007-08-16 10:43

select distinct  lr.result, lp.patient_first_name, lp.patient_last_name, lp.collection_date  from labTestResults lr, labPatientPhysicianInfo lp where lr.test_name = 'HEMOGLOBIN A1C' and  lr.result != 'PND'  and lr.result > 0.07 and lr.labPatientPhysicianInfo_id = lp.id;