$strSQL = "SELECT * FROM drug_detail,drug_unit,drug_type WHERE (drug_id LIKE '%$key%' or drug_name1 LIKE '%$key%' or drug_name2 LIKE '%$key%' ) and drug_detail.unit_id=drug_unit.unit_id and drug_detail.type_id=drug_type.type_id";
จะรวมกับ
$strSQL = "SELECT distinct sum(quantity) as total FROM sup_inv_detail group by drug_id ";
SELECT * (เลือกตามใจชอบอยากใส่ฟิลด์อะไรก็ใส่ครับ)
FROM
drug_detail a
left outer join drug_unit b
on a.unit_id=b.unit_id
left outer join drug_type c
on a.type_id=b.type_id
left outer join (SELECT drug_id,sum(quantity) as total FROM sup_inv_detail group by drug_id) d
on a.drug_id = d.drug_id
WHERE (a.drug_id LIKE '%$key%' or a.drug_name1 LIKE '%$key%' or a.drug_name2 LIKE '%$key%' )
Load balance : Server 03
