错误见图,
原因是包含SUM等聚合函数的查询语句,select 后面的字段必须要么出现在groupby中,要么出现在函数里。
按以下更改成功。
SELECT dbo.NewquotationBill.QttDate, dbo.NewquotationBill.QttNo, dbo.NewquotationBill.Customer, dbo.NewquotationBill.ProductName, dbo.NewquotationBill.Materialcoding,
dbo.NewquotationBill.Estimatedannualdosage, SUM(dbo.NewquotationList.Amount) AS Expr1, dbo.NewquotationBill.Explain, dbo.NewquotationBill.Inputman
FROM dbo.NewquotationBill INNER JOIN
dbo.NewquotationList ON dbo.NewquotationBill.QttNo = dbo.NewquotationList.QttNo
GROUP BY dbo.NewquotationBill.QttDate, dbo.NewquotationBill.QttNo, dbo.NewquotationBill.Customer, dbo.NewquotationBill.ProductName,
dbo.NewquotationBill.Materialcoding, dbo.NewquotationBill.Estimatedannualdosage, dbo.NewquotationBill.Explain, dbo.NewquotationBill.Inputman