回答：数据库里面的字段类型没有单独的time的，需要datetime类型才行

回答：SELECT c.depart_name 部门,count(distinct  b.emp_fname) 出勤人数,FROM dbo.TimeRecords a     INNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_id     INNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_idWHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)AND LEFT(b.depart_id, 9) IN ('008010101', '008010102', '008010103')group by c.depart_name