$strSQL3 = "SELECT * FROM datadrug.tbl_drugname AS d,datadrug.tbl_meth_eat AS e,datadrug.tbl_method_drug AS m where d.drug_id=e.drug_id AND e.id_method= m.id_method ";
แบบ 1 database 3 table
$sql = "SELECT * FROM datadrug.tbl_danger AS i ,datadrug.tbl_drugname AS d ,dataopd.tbl_opd AS o ,dataopd.tbl_room AS l ,dataopd.tbl_admit AS a,datadrug.tbl_drug_eat AS e ";
$sql = $sql . "WHERE i.drug_id=d.drug_id and i.number = o.number and i.CartID <> '0' and i.amount >'0' and i.vn_no =a.id_adm AND i.drug_id = e.drug_id AND i.CartID = e.CartID and i.go_home >='2' and a.id_room = l.id_room and a.admit = '1' and l.ward_id ='4' and i.date_input >='2004-05-01' limit 0,30 ";
Load balance : Server 03
