select m1.*,concat(s.name,' ',s.strength,' ',s.units) as name ,concat(s.name,' ',s.strength,' ',s.units) as dname,d.shortlist ,
m1.qty as med_order_number, m1.qty as med_plan_number,i.displaycolor,
m1.sum_price as total_price
from opitemrece m1
left outer join s_drugitems s on s.icode=m1.icode
left outer join drugusage d on d.drugusage=m1.drugusage
left outer join drugitems i on i.icode=m1.icode
where m1.an='520001664' and m1.item_type='H' order by item_no
หัวข้อ: ขอ Code ที่ดึงหน้าฟอร์มนี้คับ (อ่าน 2803 ครั้ง)