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

select (p.house_regist_type_id)as PCU,(t.type_area) as CARD,p.cid,t.hn,t.last_visit,t.sex,p.age_y,v.village_name,d.name
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 thaiaddress d on d.chwpart=t.chwpart and d.amppart=t.amppart and d.tmbpart=t.tmbpart
where p.house_regist_type_id in (‘1′,’2’) and p.house_regist_type_id<>t.type_area
order by p.village_id