sql 错误

[wis2007]

Aselect CommodityName,CompanyName,IsNull(count(tb_Reckoning.CommodityId)+1,1) as 结款次数,convert(varchar(8),tb_Stock.StockDate,112)+ right('0000000'+ltrim(tb_Stock.id),7) as 单据编号 from tb_Company,tb_Commodity,tb_Stock,tb_Reckoning where tb_Company.id=tb_Stock.CompanyId and tb_Commodity.id=tb_Stock.CommodityId and tb_Stock.Type='进货信息' and tb_Reckoning.CommodityId=tb_Stock.id
group by tb_Stock.Type,tb_Commodity.CommodityName,
tb_Company.CompanyName,tb_Stock.StockDate,tb_Stock.id,tb_Reckoning.CommodityId



在添加结款次数列，根据tb_Stock.CommodityId 查询tb_Reckoning 表的CommodityId 如果有就显示，没有就赋值为'1'。 遇到'count' 附近有语法错误。

[水族杰纶]

--沒發現錯誤
select CommodityName,CompanyName,IsNull(count(tb_Reckoning.CommodityId)+1,1) as 结款次数,convert(varchar(8),tb_Stock.StockDate,112)+ right('0000000'+ltrim(tb_Stock.id),7) as 单据编号 from tb_Company,tb_Commodity,tb_Stock,tb_Reckoning where tb_Company.id=tb_Stock.CompanyId and tb_Commodity.id=tb_Stock.CommodityId and tb_Stock.Type='进货信息' and tb_Reckoning.CommodityId=tb_Stock.id 
group by tb_Stock.Type,tb_Commodity.CommodityName, 
tb_Company.CompanyName,tb_Stock.StockDate,tb_Stock.id,tb_Reckoning.CommodityId 

[wsh236]

好像没有错误呀！

[wis2007]

错了没有赋值为1
应该是这样的结果


可是我查询出来的为