BMS-HOSxP Community
HOSxP => การเขียน SQL Script => ข้อความที่เริ่มโดย: doitao ที่ สิงหาคม 31, 2012, 15:02:21 PM
-
select v.hn,v.vstdate,c.number,concat(p.pname,p.fname," ",p.lname) as ptname,
lb.lab_items_normal_value_ref as normal,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 '2010-10-01' and '2011-10-31'
and c.clinic =(select sys_value from sys_var where sys_name='dm_clinic_code')
and lb.lab_order_result <=100 and lb.lab_items_code in ("160")
order by v.vstdate