เบาหวาน ความดัน เบาหวานร่วมความดัน
select concat(p.pname,p.fname,’ ‘,p.lname)as name,ad.full_name,dm.hn,dm.icd10,dm.dxtype,dm.clinic,ht.icd10,ht.dxtype,ht.clinic from (select * from clinic_persist_icd where icd10 between ‘e10’ and ‘e149’ group by hn) as dm
left join (select * from clinic_persist_icd where icd10 between ‘i10’ and ‘i159′ group by hn)as ht
on ht.hn=dm.hn
left join patient p on p.hn=dm.hn
left join thaiaddress ad on ad.chwpart=p.chwpart and ad.amppart=p.amppart and ad.tmbpart=p.tmbpart
where ht.icd10 is null
order by p.chwpart,p.amppart,p.tmbpart //เบาหวาน
select concat(p.pname,p.fname,’ ‘,p.lname)as name,ad.full_name,ht.hn,ht.icd10,ht.dxtype,ht.clinic,dm.icd10,dm.dxtype,dm.clinic from (select * from clinic_persist_icd where icd10 between ‘e10’ and ‘e149’ group by hn) as dm
right join (select * from clinic_persist_icd where icd10 between ‘i10’ and ‘i159′ group by hn)as ht
on ht.hn=dm.hn
left join patient p on p.hn=ht.hn
left join thaiaddress ad on ad.chwpart=p.chwpart and ad.amppart=p.amppart and ad.tmbpart=p.tmbpart
where dm.icd10 is null
order by p.chwpart,p.amppart,p.tmbpart // ความดัน
select concat(p.pname,p.fname,’ ‘,p.lname)as name,ad.full_name,a.hn,a.icd10,a.dxtype,a.clinic,b.icd10,b.dxtype,b.clinic from (select * from clinic_persist_icd where icd10 between ‘i10’ and ‘i159’)as a
inner join (select * from clinic_persist_icd where icd10 between ‘e10’ and ‘e149’)as b
on a.hn=b.hn and a.icd10<>b.icd10
left join patient p on p.hn=a.hn
left join thaiaddress ad on ad.chwpart=p.chwpart and ad.amppart=p.amppart and ad.tmbpart=p.tmbpart
order by p.chwpart,p.amppart,p.tmbpart // เบาหวานร่วมความดัน
ความเห็นล่าสุด