求助 GROUP分组 严重问题
SELECT T_Goods_Day_Sale.store_id, T_Goods_Day_Sale.goods_id, T_Goods_Day_Sale.barcode, SUM(T_Goods_Day_Sale.qty) AS Expr1,
T_Goods_Day_Sale.sale_date, SUM(T_Goods_Day_Sale.ramt) AS Expr2,
T_Goods.goods_name
FROM T_Goods_Day_Sale INNER JOIN
T_Goods ON T_Goods_Day_Sale.goods_id = T_Goods.Goods_id
WHERE (T_Goods_Day_Sale.sale_date =2007-8-15)
GROUP BY T_Goods.goods_name
