 |
ช่วยดู error You have an error in your SQL syntax; ให้หน่อยค่ะ |
| |
 |
|
|
 |
 |
|
ดูline4ดีๆครับ รูปแบบมันผิด
|
 |
 |
 |
 |
| Date :
2013-02-28 16:16:55 |
By :
matay107 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ตามนี้
Code (PHP)
$sql = "SELECT b.Id, b.BranchName,
(SELECT SUM(PlanQty) FROM planstock WHERE ProductCode = 'KT08J' AND BranchId= b.Id GROUP BY ProductCode) as KT08J,
(SELECT SUM(PlanQty) FROM planstock WHERE ProductCode = 'KT08' AND BranchId = b.Id GROUP BY ProductCode) as KT08,
(SELECT SUM(PlanQty) FROM planstock WHERE ProductCode = 'KT09' AND BranchId = b.Id GROUP BY ProductCode) as KT09,
(SELECT SUM(PlanQty) FROM planstock WHERE 'ProductCode' = 'KT11' AND BranchId = b.Id GROUP BY ProductCode) as KT11,
(SELECT SUM(PlanQty) FROM planstock WHERE ProductCode = 'KT12' AND BranchId = b.Id GROUP BY ProductCode) as KT12
FROM branchstock b";
|
ประวัติการแก้ไข
2013-02-28 16:32:47
| |
|
|
| |
| Date :
2013-02-28 16:18:23 |
By :
mangkunzo |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
