2,498
社区成员
发帖
与我相关
我的任务
分享
select A.人员编号,A.姓名,B.部门,C.职位,C.报账上限,
iif(D.amt is null,0,amt) as 已报总额,
C.报账上限-iif(D.amt is null,0,amt) as 剩余可报额 from
((人员信息表 as A left join 部门信息表 as B on A.部门编号=B.部门编号)
Left join 职位信息表 as C on A.职位编号=C.职位编号)
left join (select 人员编号,sum(报账额) as amt from 报账明细表 group by 人员编号) as D
on A.人员编号=D.人员编号
建表字段最好不要用中文