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

select distinct  v.hn,v.vstdate,c.number,concat(p.pname,p.fname,”  “,p.lname) as ptname,lb.lab_order_result as LDL
from vn_stat  v
left outer join lab_head lh on lh.vn=v.vn
left outer join opdscreen o on o.vn=v.vn
left outer join patient p on p.hn=v.hn
left outer join lab_order lb on lb.lab_order_number=lh.lab_order_number
left outer join clinicmember c on c.hn=v.hn
where  v.vstdate between ‘2009-02-01’ and ‘2009-06-31’ and c.clinic =”001″ and v.spclty =”01” and  lb.lab_order_result <=130 and lb.lab order_result is not null and lb.lab_order_result <>””and lb.lab_items_code in (‘3073’, ‘3045’, ‘3001’, ‘3036’)

0

0