一、题目
二、代码
/*
核心是连接(以领导表作为连接表):
*/
# select sa.emp_no, sa.salary , sa.from_date,sa.to_date, de.dept_no
# from salaries sa right join dept_manager de on sa.emp_no=de.emp_no
# order by emp_no
select sa.emp_no, sa.salary, sa.from_date, sa.to_date, de.dept_no
from salaries sa right join dept_manager de on sa.emp_no=de.emp_no
order by emp_no asc