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

select t.last_update,t.cid,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.sex,p.birthdate,t.hn,p.house_regist_type_id,t.type_area,
v.village_name,v.village_moo,t.addrpart,t.moopart,t.chwpart,t.amppart,t.tmbpart
from person p
left join patient t on t.cid=p.cid
left join village v on v.village_id=p.village_id
left join vn_stat s on s.hn=p.patient_hn
where p.house_regist_type_id in (‘1′,’2′,’3′,’4’) and p.house_regist_type_id<>t.type_area and t.last_update <>”
group by s.hn

0

0