select o.hn,v.cid,p.pname,p.fname,p.lname,p.birthday,concat(v.age_y,’.’,v.age_m)as age,v.vstdate,o.egfr,o.hba1c,v.pdx,v.dx0,v.dx1,v.dx2,v.dx3,v.dx4,v.dx5
from opdscreen o
left join vn_stat v on v.hn=o.hn
left join patient p on p.hn=v.hn
where o.hba1c is not null and o.hba1c < 7
group by o.hn
ความเห็นล่าสุด