มี error ครับ เป็นบางรายน่ะครับ แก้ไขอย่างไรครับ 7.1 : Hospital Code = 10748 [โรงพยาบาล ปัตตานี] Database Type = MySQL Database Protocol = mysql-4.1 Last 3 SQL Statement . No 1 = select o.*,concat(s.name,' ',s.strength,' ',s.units) as name ,d.shortlist from medplan_ipd o left outer join s_drugitems s on s.icode=o.icode left outer join drugusage d on d.drugusage=o.drugusage where o.an='500002455' and o.orderdate<='2007-03-07' and (o.offdate>='2007-03-07' or o.offdate = '1899-12-30' or o.offdate IS NULL) order by o.icode_type,o.med_plan_number . No 2 = select must_paid,high_cost,use_right from drugitems where icode='0' . No 3 = select icode from nondrugitems where name='' . Server variable