看到部分思路不完全,请勿忽略排序!!order by s.emp_no
SELECT s.*, d.dept_no FROM salaries AS s , dept_manager AS d WHERE s.emp_no=d.emp_no order by s.emp_no;
看到部分思路不完全,请勿忽略排序!!order by s.emp_no
SELECT s.*, d.dept_no FROM salaries AS s , dept_manager AS d WHERE s.emp_no=d.emp_no order by s.emp_no;