您所在位置：主题：SQL求各语句
VCII
[专家分：1710] 发布于 2008-04-23 11:15:00
select t.taocanName,o.taocanCount From [order] as o,taocan as t where o.loupanID=3 And o.taocanID=t.ID
这个语句执行的效果如下图，现在想把相同taocanName的数量加起来，如
牛肉煎蛋饭 6
干烧对虾 6
==========================
select t.taocanName,o.taocanCount From [order] as o,taocan as t where o.loupanID=3 And o.taocanID=t.ID group by o.taocanCount,t,taocanName
如果换成这语句，taocanCount总数是错误的
这个语句执行的效果如下图，现在想把相同taocanName的数量加起来，如
牛肉煎蛋饭 6
干烧对虾 6
==========================
select t.taocanName,o.taocanCount From [order] as o,taocan as t where o.loupanID=3 And o.taocanID=t.ID group by o.taocanCount,t,taocanName
如果换成这语句，taocanCount总数是错误的
