ที่ผมพิมพ์ออกซ้ำทั้ง ipd เเละ opd เลยครับ
เป็นบางคนนะครับ ไม่ทราบว่าเพราะตรวจ 2 คลินิกหรือเปล่า เป็นหลังจาก activate เวอร์ชั่นครับ 3.55.12.6 ครับ
FORM-Sticker-IPD-Detail
select d1.*,v1.*,o1.*
from doctor_order_print d1
left outer join an_stat v1 on v1.an=d1.vn
left outer join ipt o1 on o1.an=d1.vn
where d1.vn="460101819" and d1.print_server="MANOI-NOTEBOOK"
group by d1.icode
FORM-Sticker-IPD-Summary
select d1.*,v1.*,o1.*
from doctor_order_print d1
left outer join an_stat v1 on v1.an=d1.vn
left outer join ipt o1 on o1.an=d1.vn
where d1.vn="460101819" and d1.print_server="MANOI-NOTEBOOK"
group by d1.icode
FORM-Sticker-OPD-Detail
select d1.*,v1.*,o1.*
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
where d1.vn="470531084436" and d1.print_server="MANOI-NOTEBOOK"
and d1.print_mode=2 and d1.print_status<>'Y'
group by d1.icode
FORM-Sticker-OPD-Summary
select d1.*,v1.*,o1.*
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
where d1.vn="470531084436" and d1.print_server="MANOI-NOTEBOOK"
and d1.print_mode=1
group by d1.icode