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

select p.age_y,p.age_m,t.icd10tm_operation_code,d.* from dtmain d
left join dtmain_area t on t.dtmain_id=d.dtmain_id
left join person p on p.patient_hn=d.hn
where t.icd10tm_operation_code in (‘2387030’) and d.vstdate between ‘2013-05-01’ and ‘2014-04-31’ and p.age_y in (‘7′,’8′)
group by d.hn

————————————————————————————————

select v.village_school_class_id,v.discharge,p.cid,p.patient_hn,concat(p.pname,p.fname,’ ‘,p.lname)as name,d.vstdate,d.icd9,t.icd10tm_operation_code
from village_student v
left join person p on p.person_id=v.person_id
left join dtmain d on d.hn=p.patient_hn
left join dtmain_area t on t.dtmain_id=d.dtmain_id
where v.village_school_class_id=’5’ /* and (t.icd10tm_operation_code in (‘2387030’)) and (d.vstdate between ‘2013-05-01’ and ‘2014-04-30′) */ and v.discharge <>’Y’
group by p.cid