http://203.157.15.4/index.php?send=softselect '11278' as Hospital,chwpart as IDPv,v.vstdate as Daterec,v.cid as IDCard,p.hn as HN ,pname as Title , fname as NPatient,Lname as Spatient,Birthday as Birthday,age_y as Age,
p.Sex,s.bw as Weight,s.height as High,s.bpd+'/'+s.bps as Effect,addrpart as No,p.moopart as Moo,space(2) as Lane,p.road as Road,aid as Address,nationality as Nation,
p.occupation as Occupation,space(16) as Datesick,space(17) as Chornic,space(18) as code,pdx as Diagnosis,space(20) as Remark,space(21) as Death,space(22) as Casue from vn_stat v
left outer join patient p on p.hn= v.hn
left outer join opdscreen s on s.vn= v.vn
where v.vstdate between "2008-03-01" and "2008-03-29"
and v.age_y>= 0
and v.age_y<= 200
and ( (v.pdx >= "E100" and v.pdx <= "E149")
or (v.dx0 >= "E100" and v.dx0 <= "E149")
or (v.dx1 >= "E100" and v.dx1 <= "E149")
or (v.dx2 >= "E100" and v.dx2 <= "E149")
or (v.dx3 >= "E100" and v.dx3 <= "E149")
or (v.dx4 >= "E100" and v.dx4 <= "E149")
or (v.dx5 >= "E100" and v.dx5 <= "E149") )
limit 10
หัวข้อ: Chronic Disease Surveillance version2.10 (อ่าน 7224 ครั้ง)