คัดกรองตา
select concat(p.pname,p.fname,’ ‘,p.lname)as name,t.full_name,c.hn,c.screen_date,c.vn,concat(p.chwpart,p.amppart,p.tmbpart)as tbb,c.*
from clinicmember_cormobidity_screen c
left join clinicmember_cormobidity_eye_screen c2 on c2.clinicmember_cormobidity_screen_id=c.clinicmember_cormobidity_screen_id
left join patient p on p.hn=c.hn
left join thaiaddress t on t.chwpart=p.chwpart and t.amppart=p.amppart and t.tmbpart=p.tmbpart
where (c.screen_date between ‘2013-10-01’ and ‘2014-05-31′) and (c.do_eye_screen=’Y’)
group by c.hn
order by c.screen_date,full_name
ความเห็นล่าสุด