两个表,goods和goodsitem,其中用code进行关联,其中需要查询name,还需要查询count（number）,怎么搞select(s.CName)asgoodsName,count(i.CNumber)asgoodsNumberfromgoodss,goodsItemiwherei.CGoodsCode=s.CCodegroupbys

Question

两个表,goods和goodsitem,其中用code进行关联,其中需要查询name,还需要查询count（number）,怎么搞
select (s.C_Name) as goodsName,count(i.C_Number) as goodsNumber from goods s ,goodsItem i where i.C_GoodsCode = s.C_Code group by s.C_Name
这么写的话goodsNumber 查询的值都为1,请问该怎么写?

Answer 1

不明白你要NAME的COUNT还是名字、1.select a.name,count(b.number) goodsnumber from goods a,goodsitem b where a.code = b.code group by a.name,2 select count(a.name) goodsname,count(b.number) goodsnumber f...