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

select i.icd10,i.dxtype,n.name,c.*
from clinicmember c
left join clinic_persist_icd i on i.hn=c.hn and i.clinic=c.clinic
left join clinic n on n.clinic=c.clinic
where i.icd10 is null or i.icd10=”

select * from clinic_persist_icd where hn in(select hn from clinic_persist_icd
group by hn
having count(hn)>2)
order by hn,dxtype