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

select person.cid,person.pname,person.fname,person.lname,clinicmember.clinic_member_status_id,person.death,
patient.hn
from person
inner join clinicmember on person.patient_hn=clinicmember.hn
inner join patient on person.cid=patient.cid
where person.death=”y” and clinicmember.clinic_member_status_id <>2
group by cid

ดึงข้อมูลจาก clinic มาแก้ไข clinic_member_status_id ให้ 2

select clinicmember_id,clinic,hn,clinic_member_status,regedit

from clinicmember

where hn=’xxxxxxx’ and clinic_member_status_id <>2

0

0