select d1.item_no as no_item,d1.*,v1.*,o1.*,p.drugallergy,
s.bw,s.bps,s.bpd,s.temperature,s.pulse,s.rr,s.height,s.note,s.bmi,s.cc,
i1.name as pdx_name
from doctor_order_print d1
left outer join vn_stat v1 on v1.vn=d1.vn
left outer join ovst o1 on o1.vn=d1.vn
left outer join opdscreen s on s.vn=d1.vn
left outer join patient p on p.hn = v1.hn
left outer join icd101 i1 on i1.code=v1.main_pdx
where d1.vn="520610000019" and d1.print_server="NURSE"
order by no_item
ลองดูนะค่ะ ตัวอย่างที่ส่งมาให้ ขนาดA5 ค่ะ