โรงพยาบาลจอมพระ

select pt.hn,concat(pt.pname,pt.fname,’ ‘,pt.lname),lo.lab_order_result ,lo.lab_items_name_ref,lo.lab_items_normal_value_ref
from clinicmember cm
left join opdscreen os on cm.hn=os.hn
left join patient pt on os.hn=pt.hn
left join lab_head lh on os.hn=lh.hn
left join lab_order lo on lh.lab_order_number=lo.lab_order_number
where (cm.clinic=’001’ )