select * from (select v.hn,concat(p.pname,p.fname,space(3),p.lname) as ptname, v.aid,cm.clinic,
(select lo.lab_order_result from lab_order lo
left outer join lab_head lh on lh.lab_order_number=lo.lab_order_number
where lo.lab_items_code="116" and lh.hn=v.hn
and lh.order_date between "2012-10-01" and "2013-05-31"
order by lh.report_date desc,lh.report_time desc limit 0,1) as fbs
,
(select lo2.lab_order_result from lab_order lo2
left outer join lab_head lh2 on lh2.lab_order_number=lo2.lab_order_number
where lo2.lab_items_code="116" and lh2.hn=v.hn
order by lh2.report_date desc,lh2.report_time desc limit 1,1) as fbs1
,
(select lo3.lab_order_result from lab_order lo3
left outer join lab_head lh3 on lh3.lab_order_number=lo3.lab_order_number
where lo3.lab_items_code="116" and lh3.hn=v.hn
order by lh3.report_date desc,lh3.report_time desc limit 2,1) as fbs2
from vn_stat v
left join patient p on p.hn = v.hn
left join clinicmember cm on cm.hn=v.hn
where v.vstdate between "2012-10-01" and "2013-05-31" and cm.clinic="001"
and cm.hn not in (select hn from clinicmember where clinic="002")
group by v.hn
order by v.aid desc ,p.pname,p.fname,p.lname) as ttemp
where fbs between 70 and 130
and fbs1 between 70 and 130
and fbs2 between 70 and 130
ลองดูครับ FBS 3 ครั้ง ติดต่อกัน และมีค่า ระหว่าง 70-130
หัวข้อ: ขอรายงานผู้ป่วยเบาหวานที่ FBS<130 ติดต่อกัน 3 ครั้งคับ (อ่าน 14088 ครั้ง)