查找所有已经分配部门的员工的last_name和first_name

 题目:

  题目描述
  查找所有已经分配部门的员工的last_name和first_name
  CREATE TABLE `dept_emp` (
  `emp_no` int(11) NOT NULL,
  `dept_no` char(4) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  PRIMARY KEY (`emp_no`,`dept_no`));
  CREATE TABLE `employees` (
 `emp_no` int(11) NOT NULL,
 `birth_date` date NOT NULL,
  `first_name` varchar(14) NOT NULL,
 `last_name` varchar(16) NOT NULL,
 `gender` char(1) NOT NULL,
 `hire_date` date NOT NULL,
 PRIMARY KEY (`emp_no`));

sql语句:

select e.last_name, e.first_name, d.dept_no
from dept_emp d, employees e
where d.emp_no = e.emp_no