![]() ![]() ![]() ![]() |
|||||
|
|||||
樓主 寒心 ![]()
![]() |
FROM Manufacture_SYS_2 LEFT JOIN Manufacture_SYS_3 ON Manufacture_SYS_3.S2_ID=Manufacture_SYS_2.ID WHERE S1_ID = %s GROUP BY Manufacture_SYS_2.ID ORDER BY Manufacture_SYS_2.Model 當我使用↑時~可以正確的計算出SUM(Manufacture_SYS_3.Inventory) 算出來的合計值 SELECT Manufacture_SYS_2.ID, Manufacture_SYS_2.S1_ID, Manufacture_SYS_2.Model,SUM(Manufacture_SYS_4.Sold) FROM Manufacture_SYS_2 LEFT JOIN Manufacture_SYS_4 ON Manufacture_SYS_4.S2_ID=Manufacture_SYS_2.ID WHERE S1_ID = %s GROUP BY Manufacture_SYS_2.ID ORDER BY Manufacture_SYS_2.Model 當我使用↑時~也可以正確的計算出SUM(Manufacture_SYS_4.Sold) 算出來的合計值 SELECT Manufacture_SYS_2.ID, Manufacture_SYS_2.S1_ID, Manufacture_SYS_2.Model,SUM(Manufacture_SYS_4.Sold), SUM(Manufacture_SYS_3.Inventory) FROM Manufacture_SYS_2 LEFT JOIN Manufacture_SYS_4 ON Manufacture_SYS_4.S2_ID = Manufacture_SYS_2.ID LEFT JOIN Manufacture_SYS_3 ON Manufacture_SYS_3.S2_ID=Manufacture_SYS_2.ID WHERE S1_ID = %s GROUP BY Manufacture_SYS_2.ID ORDER BY Manufacture_SYS_2.Model 但是當我使用↑時若Manufacture_SYS_4.Sold或Manufacture_SYS_3.Inventory的筆數大於2筆時~計算就會有問題...這是為什麼呢? 語法哪裡錯誤了~求各位大大教學一下~ |