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

select p.cid,p.patient_hn,concat(p.pname,p.fname,’ ‘,p.lname)as name,p.death,p.death_date,
c.clinic_member_status_id,clinic_member_status_name
from clinicmember c
left join person p on p.patient_hn=c.hn
left join clinic_member_status s on s.clinic_member_status_id=c.clinic_member_status_id
where c.clinic_member_status_id=’2′ and p.death=’N’
group by p.cid