VFP 愛用者社區

[mol]

SELECT Totallist.*, SUM(Maintable.quantity) As Quantity, AVG(Maintable.price) As Price,;
SUM(Maintable.amount) As Amount, Sum(Maintable.amount_usa) As Amount_USA;
FROM cims!totallist RIGHT OUTER JOIN cims!maintable ;
ON Totallist.barcode = Maintable.barcode;
WHERE Maintable.auto_no = "123456";
GROUP BY Totallist.item_no;
INTO CURSOR prnTable

上列SQL语句在VFP6下可以运行，在VFP8下就报错，请高手解答。

[Ruey]

改成以下

SELECT Totallist.item_no,SUM(Maintable.quantity) As Quantity, AVG(Maintable.price) As Price,;
SUM(Maintable.amount) As Amount, Sum(Maintable.amount_usa) As Amount_USA;
FROM cims!totallist RIGHT OUTER JOIN cims!maintable ;
ON Totallist.barcode = Maintable.barcode;
WHERE Maintable.auto_no = "123456";
GROUP BY Totallist.item_no;
INTO CURSOR prnTable

[alensap]

這樣的語法可以用嗎?
Totallist.*
在Group by中應該會有問題
小弟也不是非常清楚
希望有更強的前輩可以說明 ~^_^~

[Erwin]

Ruey就是那個更強的前輩~~

[elleryq]

對呀對呀
我附議~

[Ruey]

最強的部分應該是找資料吧!!
最近沒有時間再加一些文章了.

這有點離題了..~_~