akhilquery.sql

select preg.first_name,preg.family_name,
ios.Service_Name, ios.Service_code, ios.Report_Type, 
invsam.lab_regno, preg.registration_no, text_report = case ios.Report_Type
	WHEN 'T' then (select itr.formatstr from investigation_typical_result_op itr where lab_regno=invsam.lab_regno and itr.service_code=invsam.service_code)
	ELSE 'NA'
	END
from investigation_sample_op invsam inner join patient_registration preg on invsam.Registration_No = preg.registration_no
inner join item_of_service ios on invsam.service_code = ios.Service_code
where invsam.Registration_No='10712'