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

select concat(p.pname,p.fname,’ ‘,p.lname)as name,o.hn,p2.age_y,concat(p.addrpart,’ ËÁÙè ‘,p.moopart,t.full_name ) as address,s.bps,s.bpd,o.icd10,diagtype
from ovstdiag o
left join patient p on p.hn=o.hn
left join person p2 on p2.patient_hn=o.hn
left join opdscreen s on s.vstdate=o.vstdate and s.hn=o.hn
left join thaiaddress t on t.chwpart=p.chwpart and t.amppart=p.amppart and t.tmbpart=p.tmbpart

where (o.vstdate between ‘2014-01-01’ and ‘2014-01-31’) and (o.icd10 like ‘%i10%’ or o.icd10 like ‘%i152%’) and (s.bps <140 and s.bpd<90)