$name = $objResult['MemName'];
$strSQL2 = "SELECT m.MemName FROM member as m WHERE m.MemName not in(select br.Borrow_secrurities from borrow as br) and m.MemName not in(select br.Borrow_secrurities2 from borrow as br) and m.MemName not in $name";
$strSQL2 = "SELECT m.MemName FROM member as m WHERE m.MemName not in(select br.Borrow_secrurities from borrow as br) and m.MemName not in(select br.Borrow_secrurities2 from borrow as br)";
แต่พอเงื่อนไขที่ 2 ไม่ได้
Code (PHP)
$strSQL2 = "SELECT m.MemName FROM member as m WHERE m.MemName not in(select br.Borrow_secrurities from borrow as br) and m.MemName not in(select br.Borrow_secrurities2 from borrow as br) and m.MemName not in $name";