SELECT T_Goods_Day_Sale.goods_id, SUM(T_Goods_Day_Sale.qty) AS Expr1,
SUM(T_Goods_Day_Sale.ramt) AS Expr2, T_Goods.goods_name,
T_Goods_Day_Sale.ramt - T_Goods.inprc * T_Goods_Day_Sale.qty AS MaoLi,
(T_Goods_Day_Sale.ramt - T_Goods.inprc * T_Goods_Day_Sale.qty)
/ T_Goods_Day_Sale.ramt AS MaoLiLv
FROM T_Goods INNER JOIN
T_Goods_Day_Sale ON T_Goods.Goods_id = T_Goods_Day_Sale.goods_id
WHERE (T_Goods_Day_Sale.sale_date BETWEEN @sale_dateA AND @sale_dateB)
ORDER BY T_Goods_Day_Sale.qty DESC, T_Goods_Day_Sale.ramt DESC, MaoLiLv DESC,
MaoLi DESC
group by good_names
查询的字段都要保留

你別老實發同樣的貼，還有你應該自己看一看最基本的語法，人應該學會捕魚而不是老實向人要魚。當然，開始有問題是可以理解的。

把你的逻辑关系和表结构写出来，看一下啊

SELECT T_Goods.goods_name, SUM(T_Goods_Day_Sale.qty) AS qty1,
SUM(T_Goods_Day_Sale.ramt) AS ramt1, SUM(T_Goods_Day_Sale.ramt)
- SUM(T_Goods.inprc * T_Goods_Day_Sale.qty) AS MaoLi,
(SUM(T_Goods_Day_Sale.ramt) - SUM(T_Goods.inprc * T_Goods_Day_Sale.qty))
/ SUM(T_Goods_Day_Sale.ramt) AS MaoLiLv
FROM T_Goods INNER JOIN
T_Goods_Day_Sale ON T_Goods.Goods_id = T_Goods_Day_Sale.goods_id
WHERE (T_Goods_Day_Sale.sale_date BETWEEN @sale_dateA AND @sale_dateB)
GROUP BY T_Goods.goods_name
ORDER BY qty1 DESC, ramt1 DESC, maoli DESC, maolilv DESC

问题已经解决