主题：查询

试试

Select 请假人, (Select sum(请假天数) from {请假天数} As b where a.请假人=b.请假人 And b.请假类型='事假') As 事假, (Select sum(请假天数) from {请假天数} As b where a.请假人=b.请假人 And b.请假类型='病假') As 病假 from (Select 请假人 from {请假天数} Group By 请假人) As a