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

select distinct v.vn,v.hn,v.vstdate,v.spclty,c.clinic,p.pname,p.fname,p.lname,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5,
o.bpd,o.bps,o.egfr,o.bmi,
lb1.lab_order_result as ‘BUN’,
lb2.lab_order_result as ‘CR’,
lb3.lab_order_result as ‘Uric asid’,
lb6.lab_order_result as ‘TG’,
lb7.lab_order_result as ‘Chol’,
lb8.lab_order_result as ‘K+’,
lb9.lab_order_result as ‘HDL’,
lb10.lab_order_result as ‘LDL’,
lb11.lab_order_result as ‘HbA1C’,
lb12.lab_order_result as ‘MALB+’,
lb13.lab_order_result as ‘Protein’

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 lab_order lb1 on lb.lab_order_number=lb1.lab_order_number and lb1.lab_items_code in (’77’)
left outer join lab_order lb2 on lb.lab_order_number=lb2.lab_order_number and lb2.lab_items_code in (’78’)
left outer join lab_order lb3 on lb.lab_order_number=lb3.lab_order_number and lb3.lab_items_code in (’79’)
left outer join lab_order lb6 on lb.lab_order_number=lb6.lab_order_number and lb6.lab_items_code in (‘103’)
left outer join lab_order lb7 on lb.lab_order_number=lb7.lab_order_number and lb7.lab_items_code in (‘102′)
left outer join lab_order lb8 on lb.lab_order_number=lb8.lab_order_number and lb8.lab_items_code in (’91’)
left outer join lab_order lb9 on lb.lab_order_number=lb9.lab_order_number and lb9.lab_items_code in (’92’)
left outer join lab_order lb10 on lb.lab_order_number=lb10.lab_order_number and lb10.lab_items_code in (’81’)
left outer join lab_order lb11 on lb.lab_order_number=lb11.lab_order_number and lb11.lab_items_code in (‘198’)
left outer join lab_order lb12 on lb.lab_order_number=lb12.lab_order_number and lb12.lab_items_code in (‘225′)
left outer join lab_order lb13 on lb.lab_order_number=lb13.lab_order_number and lb13.lab_items_code in (’45’)

left outer join clinicmember c on c.hn=v.hn
where v.vstdate between ‘2012-11-01’ and ‘2013-05-31′ and v.spclty=’13’ and c.clinic in (‘001′,’002’)
and lb.lab_items_code in (‘225′,’77’,’78’,’79’,’103′,’102′,’91’,’92’,’81’,’198′,’45’)

0

0