sql 语句sum(）示和空值显示为0

yncxlyq · 发表于 2015-9-24 22:56

select [Sheet2$].序号, [Sheet2$].纳税人识别号, [Sheet2$].纳税人名称, [Sheet2$].征收项目,sum([Sheet1$].实缴税额) as 实缴税额,count([Sheet1$].纳税人识别号) as 笔数 from [Sheet2$] left join [Sheet1$] on ( [Sheet2$].纳税人识别号=[Sheet1$].纳税人识别号 and [Sheet2$].征收项目=[Sheet1$].征收项目 ) where [Sheet2$].征收项目='增值税'
group by [Sheet2$].序号, [Sheet2$].纳税人识别号, [Sheet2$].纳税人名称, [Sheet2$].征收项目

也就是：sum([Sheet1$].实缴税额) as 实缴税额如何用iif(isnull（））来表示

yncxlyq · 发表于 2015-9-24 23:14

请各位高手赐教

yncxlyq · 发表于 2015-9-25 09:38

谢谢，已解决：

select [Sheet2$].序号, [Sheet2$].纳税人识别号, [Sheet2$].纳税人名称, [Sheet2$].征收项目,
sum(iif(isnull([Sheet1$].实缴税额),0, [Sheet1$].实缴税额)) as 实缴税额,count([Sheet1$].纳税人识别号) as 笔数 from [Sheet2$] left join [Sheet1$] on ( [Sheet2$].纳税人识别号=[Sheet1$].纳税人识别号 and [Sheet2$].征收项目=[Sheet1$].征收项目 ) where [Sheet2$].征收项目='增值税'group by [Sheet2$].序号, [Sheet2$].纳税人识别号, [Sheet2$].纳税人名称, [Sheet2$].征收项目

sum([Sheet1$].实缴税额) as 实缴税额替换成sum(iif(isnull([Sheet1$].实缴税额),0, [Sheet1$].实缴税额)) as 实缴税额

		自动登录	找回密码
密码			免费注册