รบกวนดูรายงานให้หน่อยครับ

[jam10]

รายงานของแพทย์แผนไทยครับ ผมใส่สิทธิคนไข้แต่ไม่ขึ้นครับ มันผิดตรงอ่ะครับ รบกวนอาจาร์ยทั้งหลายช่วยด้วยครับผม

select o.rxdate, o.vn, p.cardno, concat(pt.pname, pt.fname, ' ', pt.lname) as ptname, v.pdx, i.name as icd10name, i.tname, v.age_y, d.name as drugname
from opitemrece_summary o
left outer join vn_stat v on v.vn=o.vn
left outer join ptcardno p on p.hn=v.hn and p.cardtype='01'
left outer join s_drugitems d on d.icode=o.icode
left outer join ovstdiag ov on ov.vn=o.vn
left outer join icd101 i on i.code=v.pdx
left outer join patient pt on pt.hn=v.hn
left outer join pttype a on a.name= i.name
where o.rxdate between '2011-01-01' and '2011-09-31'
and o.icode in ("3000573","3000492","3001565","3000511","3001630","3001629","3001564","3001668","3001667")
group by o.vn
order  by o.vn

[golf_win]

select o.rxdate, o.vn, p.cardno, concat(pt.pname, pt.fname, ' ', pt.lname) as ptname, v.pdx, i.name as icd10name, i.tname, v.age_y, d.name as drugname,a.name as pttype
from opitemrece_summary o
left outer join vn_stat v on v.vn=o.vn
left outer join ptcardno p on p.hn=v.hn and p.cardtype='01'
left outer join s_drugitems d on d.icode=o.icode
left outer join ovstdiag ov on ov.vn=o.vn
left outer join icd101 i on i.code=v.pdx
left outer join patient pt on pt.hn=v.hn
left outer join pttype a on a.pttype= v.pttype
where o.rxdate between '2011-01-01' and '2011-09-31'
and o.icode in ("3000573","3000492","3001565","3000511","3001630","3001629","3001564","3001668","3001667")
group by o.vn
order  by o.vn

ลองแบบนี้ได้หรือป่าวครับ

[jam10]

ได้แล้วครับอาจาร์ย ก๊อฟ ขอบคุณมากๆๆๆๆๆครับ ไม่ได้อาจาร์ยก๊อฟผมแย่แน่เลย 

select o.rxdate, o.vn, p.cardno, concat(pt.pname, pt.fname, ' ', pt.lname) as ptname, v.pdx, i.name as icd10name, i.tname, v.age_y, d.name as drugname,a.name as pttype
from opitemrece_summary o
left outer join vn_stat v on v.vn=o.vn
left outer join ptcardno p on p.hn=v.hn and p.cardtype='01'
left outer join s_drugitems d on d.icode=o.icode
left outer join ovstdiag ov on ov.vn=o.vn
left outer join icd101 i on i.code=v.pdx
left outer join patient pt on pt.hn=v.hn
left outer join pttype a on a.pttype= v.pttype
where o.rxdate between '2011-01-01' and '2011-09-31'
and o.icode in ("3000573","3000492","3001565","3000511","3001630","3001629","3001564","3001668","3001667")
group by o.vn
order  by o.vn

ลองแบบนี้ได้หรือป่าวครับ