如何默认为零???急急急急!

[yinfox1]

select 员工基础工资数据.ID, sum(缺勤) as 缺勤数 from 员工基础工资数据 LEFT JOIN 员工缺勤 ON 员工基础工资数据.ID = 员工缺勤.员工ID group by 员工基础工资数据.ID


SQL语句如上,如果这个员工缺勤没有记录,即无缺勤,那么选出来后,如果让这个缺勤数为0,而不要为空?

即:
select 员工基础工资数据.ID, sum(缺勤) as 缺勤数 "default 0" from 员工基础工资数据 LEFT JOIN 员工缺勤 ON 员工基础工资数据.ID = 员工缺勤.员工ID group by 员工基础工资数据.ID

双引号中的是示意而已!!!!

[cheny1234]

未经测试：
select 员工基础工资数据.ID, iif(isnull(sum(缺勤),0,sum(缺勤)) as 缺勤数 from 员工基础工资数据 LEFT JOIN 员工缺勤 ON 员工基础工资数据.ID = 员工缺勤.员工ID group by 员工基础工资数据.ID

[hongbo163]

呵呵，我帮你测试了
没问题

[changechange]

在ACCESS环境中直接用NZ即可

select 员工基础工资数据.ID, nz(sum(缺勤),0) as 缺勤数 from 员工基础工资数据 LEFT JOIN 员工缺勤 ON 员工基础工资数据.ID = 员工缺勤.员工ID group by 员工基础工资数据.ID