1 select a.code as 员工ID , a.name as 员工名字, sum(b.分数) as 总分数,count(b.员工id) as 评分次数
from a left join b on a.code = b.员工id
group by a.code , a.name
order by a.code
2 select a.code as 员工ID , a.name as 员工名字, dsum("分数","b","员工id=" & a.code)
as 总分数,dcount("*","b","员工id=" & a.code) as 评分次数
from a order by a.code
select a.code as 员工ID , a.name as 员工名字, sum(b.分数) as 总分数,count(b.员工id) as 评分次数
from a left join b on a.code = b.员工id
group by a.code , a.name
order by a.code