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

select distinct pt.hn,pt.cid,concat(pt.pname,pt.fname,’ ‘,pt.lname)as name,pt.addrpart ,pt.moopart,pt.tmbpart,pt.amppart,pt.chwpart
from patient pt,clinicmember c
where pt.hn = c.hn and c.clinic=’001′ and pt.chwpart=’32’ and pt.amppart=’04’ and pt.tmbpart=’01’
order by pt.moopart