นี้คือชุดคำสั่งของ form-screen-opdcard ที่มีอยู่เดิม
select d1.*,v1.*,o1.*,s.*,t.blobtext,t.blobtext2,pe.image1,pq.staff,opdu.name as nurse_name,oa.nextdate,k.department,d.name,
opdu.entryposition,o.agent,o.symptom
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 pe_image pe on pe.vn=d1.vn
left outer join pq_screen pq on pq.vn=d1.vn
left outer join opduser opdu on opdu.loginname=pq.staff
left outer join tempreport t on t.name=d1.vn and t.reportname="DOCTOR-FORM"
left outer join opd_allergy o on o.hn=d1.hn
left outer join oapp oa on oa.vn=d1.vn
left outer join kskdepartment k on k.depcode=oa.depcode
left outer join ovstdiag ot on ot.vn=o1.vn
left outer join doctor d on d.code=ot.doctor
where d1.vn="471024184934" and d1.print_server="MANOI-NOTEBOOK" and ot.diagtype="1"