代码:
SELECT de.dept_no, de.emp_no, sa.salary
FROM dept_emp AS de
INNER JOIN salaries AS sa
ON de.emp_no = sa.emp_no
代码:
SELECT de.dept_no, de.emp_no, sa.salary
FROM dept_emp AS de
INNER JOIN salaries AS sa
ON de.emp_no = sa.emp_no