ช่วยดูคำสั่งนี้ให้หน่อยครับ

[Bond_007]

อยากได้คำสั่งคนไข้เบาหวานที่ไม่ได้ตรวจ HBA1C  ผมใช้คำสั้งนี้มีเพียง 19 record เท่านั้นไม่รู้ต้องปรับตรงไหนครับขอบคุณครับ

select distinct v.hn,concat(p.pname,p.fname," ", p.lname) as '??',p.cid,p.informtel,v.pdx,v.vstdate,h.lab_order_number,o.lab_items_code,o.lab_items_name_ref,o.lab_order_result  from vn_stat v
left outer join patient p on p.hn = v.hn
left outer join icd101 i on i.code = v.pdx
left outer join lab_head h on h.hn = v.hn
left outer join lab_order o on o.lab_order_number = h.lab_order_number
where v.pdx = 'E119' and  p.hcode = '14555'
and      lab_items_name_ref = 'HBA1C'  is null
group by v.hn

[armds]

ลองดูครับ.....

select distinct v.hn,concat(p.pname,p.fname," ", p.lname) as 'ptname',p.cid,p.informtel,v.pdx,v.vstdate,h.lab_order_number,o.lab_items_code,o.lab_items_name_ref,o.lab_order_result
from vn_stat v
left outer join patient p on p.hn = v.hn
left outer join icd101 i on i.code = v.pdx
left outer join lab_head h on h.hn = v.hn
left outer join lab_order o on o.lab_order_number = h.lab_order_number
where v.pdx = 'E119' and  p.hcode = '14555'
and      lab_items_name_ref <> 'HBA1C'
and v.vstdate between'2010-01-01'and'2010-01-31'
group by v.hn

[Bond_007]

ยังไม่ได้ครับเพราะยังมีรายชื่อคนที่ตรวจ HBA1C อยู่คับ

[armds]

ลองดูใหม่ครับ

select distinct v.hn,concat(p.pname,p.fname," ", p.lname) as 'ptname',p.cid,p.informtel,v.pdx,v.vstdate,h.lab_order_number,o.lab_items_code,o.lab_items_name_ref,o.lab_order_result
from vn_stat v
left outer join patient p on p.hn = v.hn
left outer join icd101 i on i.code = v.pdx
left outer join lab_head h on h.vn = v.vn
left outer join lab_order o on o.lab_order_number = h.lab_order_number
where v.pdx = 'E119' and  p.hcode = '14555'
and      lab_items_name_ref <> 'HBA1C'
and v.vstdate between'2010-01-01'and'2010-01-31'
group by v.hn