查找所有已经分配部门的员工的信息

方法一:

SELECT
    e.last_name,
    e.first_name,
    de.dept_no
FROM
    employees AS e,
    dept_emp AS de
WHERE
    de.emp_no = e.emp_no;


方法二:


SELECT
    e.last_name,
    e.first_name,
    de.dept_no
FROM
    employees AS e
    INNER JOIN dept_emp AS de ON de.emp_no = e.emp_no;