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

select a.full_name as card,t.informaddr,t.type_area,p.*
from person p
left join patient t on t.cid=p.cid
left join thaiaddress a on a.chwpart= t.chwpart and a.amppart=t.amppart and a.tmbpart=t.tmbpart
where p.house_regist_type_id in (‘3’) and p.village_id in (‘1’)