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

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,c2.*
from clinicmember_cormobidity_screen c
left join clinicmember_cormobidity_foot_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 (p.chwpart=’32’ and p.amppart=’04’ and p.tmbpart=’01’)
group by c.hn
order by c.screen_date

select c.*
from clinicmember_cormobidity_screen c
join patient p on p.hn=c.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=c.vn

where (c.screen_date between ‘2013-10-01’ and ‘2014-06-30′)
and (c.do_foot_screen =’Y’)
and (t.hipdata_code=’UCS’)
group by c.hn

select c.*
from clinicmember_cormobidity_screen c
join patient p on p.hn=c.hn
join pttype t on t.pttype=p.pttype
join vn_stat s on s.vn=c.vn

where (c.screen_date between ‘2013-10-01’ and ‘2014-06-30′)
and (c.do_eye_screen =’Y’)
and (t.hipdata_code=’UCS’)
group by c.hn

0

0