SQL查询问题？

[yanfeishen79]

我数据库gwk_money是FLOAT型的默认值是0 但我对其分类统计时却显示不出来0却显示为空
我的SQL语句是
select a.gwk_id,a.gwk_name,b.gwk_money from gwkxx a left join
(select gwk_id,sum(gwk_money) as gwk_money from xiaoshou group by gwk_id)b on a.gwk_id=b.gwk_id
查询时总是为空GWK——MONEY
改为
select a.gwk_id,a.gwk_name,isnull(b.gwk_money,0) as gwk_money from gwkxx a left join (select gwk_id,sum(gwk_money) as gwk_money from xiaoshou group by gwk_id)b on a.gwk_id=b.gwk_id
也不行，怎么做呢？

[pengdali]

不会吧。应该可以呀。

select a.gwk_id,a.gwk_name,isnull(b.gwk_money,0) gwk_money from gwkxx a left join (select gwk_id,sum(gwk_money) as gwk_money from xiaoshou group by gwk_id) b on a.gwk_id=b.gwk_id

[orcale]

改为:
select a.gwk_id,a.gwk_name,isnull(b.gwk_money,0) as gwk_money from gwkxx a left join (select gwk_id,isnull(sum(gwk_money,0.00) as gwk_money from xiaoshou group by gwk_id)b on a.gwk_id=b.gwk_id

[gmlxf]

你可以用isnull函数。
isNull(colname,0)