这样试试
select a.员工姓名,b.s,c.考核等级 from ((员工名单表 as a left join 员工考核表 as c on a.员工ID=c.员工ID) left join (select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b on a.员工ID=b.员工ID)
用的是Access吧
select a.员工姓名,b.s,c.考核等级 from 员工名单表 as a left join 员工考核表 as c on a.员工ID=c.员工ID left join (select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b on a.员工ID=b.员工ID
或者
select a.员工姓名,b.s,c.考核等级 from 员工名单表 as a,员工考核表 as c,(select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b where a.员工ID=b.员工ID and a.员工ID=c.员工ID
或者
select a.员工姓名,a.考核等级,b.s from (select a.员工ID,a.员工姓名,c.考核等级 from 员工名单表 as a left join 员工考核表 as c on a.员工ID=c.员工ID) as a left join (select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b on a.员工ID=b.员工ID
下面语句始终过不了,错在哪里呢?
select a.员工姓名,b.s,c.考核等级 from 员工名单表 as a,员工考核表 as c left join (select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b on a.员工ID=b.员工ID where a.员工ID=c.员工ID
@三楼一郎
谢谢指点,试了一下,通过了!
又另外将a表改为2表联查,即
select a.员工姓名,b.s,c.考核等级 from 员工名单表 as a,员工考核表 as c join (select 员工ID,sum(差旅费) as s from 员工差旅费记录 group by 员工ID) as b on a.员工ID=b.员工ID where a.员工ID=c.员工ID
就报错了,不知道为何?