求助 GROUP分组严重问题

shulei521521 发布于 2007-08-15 12:59， 767 次点击

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

4 回复

cyyu_ryh2007-08-15 13:26

有什么问题呢

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

西风独自凉2007-08-15 13:33

你先看下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

shulei5215212007-08-15 13:42

回复：（西风独自凉）你先看下group by 的用法。。。语...

顶　　非常正确

shulei5215212007-08-16 15:21

yes yes yes yes yes yes yes yes

求助 GROUP分组 严重问题

求助 GROUP分组严重问题