vagmi

-- Extract normal results
select preg.first_name,ios.Service_Name, inr.result,ulm.Unit_name, inr.min_value, inr.max_value, invsam.lab_regno
from patient_registration preg inner join (investigation_sample_op invsam
inner join (investigation_normal_result_op inr 
inner join item_of_service ios 
on ((ios.Service_code=inr.service_code) and (ios.Report_Type='N')))
on ((inr.service_code = invsam.service_code) 
     and (inr.lab_regno = invsam.lab_regno)))
on preg.registration_no = invsam.Registration_No inner join Unit_Lab_Master ulm on ulm.unit_code=inr.Unit_code
where preg.registration_no='10712'