select 领导表.emp_no,工资表.salary,工资表.from_date,领导表.to_date,dept_no from dept_manager as 领导表 left join salaries as 工资表 on 领导表.emp_no=工资表.emp_no ; ''表连接，保证领导表完整性