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

有什么问题呢

WHERE (T_Goods_Day_Sale.sale_date =‘2007-8-15’)

你先看下group by 的用法。。。
语法错了。。。选择出来的都需 group by
例：select id from table group by id
select id,name from table group by id ,name
select id,name ,sex from tabel group by id,name ,sex

顶　　非常正确

yes yes yes yes yes yes yes yes