主题：[求助]如何设计查询

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:工资表系统.zip

请问老师，我想设计一个查询，从三个表中提取数据，请问如何设计查询，谢谢老师指点`
此主题相关图片如下：`3~xf9n8td5anp6ix)n_xk.png

Select e.姓名,f.职务,f.任职时间,g.原职务,g.原任职时间 from ({基本情况表} As e Inner join (select a.编号,a.职务,a.任职时间 from {职务表} as a left join (Select 编号,max(任职时间) As 任职时间 from {职务表}  group by 编号) as b on a.编号=b.编号 where a.任职时间 = b.任职时间) as f on e.编号=f.编号) left join (select c.编号,c.职务 as 原职务,c.任职时间 as 原任职时间 from {职务表} as c inner join (Select a.编号,max(a.任职时间) as 任职时间 from {职务表} As a Inner join (Select 编号,max(任职时间) As 任职时间 from {职务表} group by 编号) As b on a.编号=b.编号 where a.任职时间 <> b.任职时间 group by a.编号) as d on c.编号=d.编号 where c.任职时间 = d.任职时间) as g on e.编号=g.编号

谢谢了，完美解决