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

select o.smoking_type_id,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.cid,p.patient_hn,concat(p.age_y,’ »Õ’)as age,concat(pt.addrpart,’ ËÁÙè ‘,pt.moopart,’ ‘,t.full_name)as address,p.house_regist_type_id,sm.smoking_type_name
from opdscreen o
left join person p on p.patient_hn=o.hn
left join smoking_type sm on sm.smoking_type_id=o.smoking_type_id
left join patient pt on pt.hn=o.hn
left join thaiaddress t on t.chwpart=pt.chwpart and t.amppart=pt.amppart and t.tmbpart=pt.tmbpart

where (o.vstdate between ‘2014-01-01’ and ‘2014-01-31’) and
(o.smoking_type_id in (‘2′,’3′) and
(p.age_y between ’15’ and ’19’)) and
(p.house_regist_type_id in (‘1′,’3′))

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

select o.drinking_type_id,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.cid,p.patient_hn,concat(p.age_y,’ »Õ’)as age,
concat(pt.addrpart,’ ËÁÙè ‘,pt.moopart,’ ‘,t.full_name)as address,p.house_regist_type_id,sm.drinking_type_name
from opdscreen o
left join person p on p.patient_hn=o.hn
left join drinking_type sm on sm.drinking_type_id=o.drinking_type_id
left join patient pt on pt.hn=o.hn
left join thaiaddress t on t.chwpart=pt.chwpart and t.amppart=pt.amppart and t.tmbpart=pt.tmbpart

where (o.vstdate between ‘2014-01-01’ and ‘2014-01-31’) and
(o.drinking_type_id in (‘2′,’3′) and
(p.age_y between ’15’ and ’19’)) and
(p.house_regist_type_id in (‘1′,’3’))