รายงานสุขภาพจิตผู้ป่วยในรายเดือน (ยังไม่เสร็จครับ)
select /*concat(p.addrpart,” ËÁÙè “,p.moopart,” µ.”,t3.name,” Í.”,t2.name,” ¨.”,t1.name,” “,p.po_code) as fulladdressname,*/v.prediag,v.hn,concat (p.pname,p.fname,’ ‘,p.lname)as nameA,
o.icd10,i.name as dx,k.name as ward,v.an
from iptdiag o
left outer join ipt v on v.an=o.an
left outer join ovst t on t.an=v.an
left outer join patient p on p.hn=v.hn
/*left outer join patient p on p.an=t.an */
/*left outer join thaiaddress t1 on t1.chwpart=p.chwpart and t1.amppart=”04″ and t1.tmbpart=”01″
left outer join thaiaddress t2 on t2.chwpart=p.chwpart and t2.amppart=p.amppart and t2.tmbpart=”01”
left outer join thaiaddress t3 on t3.chwpart=p.chwpart and t3.amppart=p.amppart and t3.tmbpart=p.tmbpart */
left outer join icd101 i on i.code=o.icd10
left outer join ward k on k.ward=v.ward
where (v.regdate between “2013-12-01” and “2013-12-31”) and (o.icd10 in (“F209″,”F29″,”F419″,”F410″,”F329″,”F76″,”Q409″,”F192″,”Q407″,”F510”))
ความเห็นล่าสุด