首先确定所要展示的属性：select e.last_name, e.first_name, d.dept_no然后确定数据来源：from employees as e inner join dept_emp as don e.emp_no = d.emp_no;具体结果：select e.last_name, e.first_name, d.dept_nofrom employees as e inner join dept_emp as don e.emp_no = d.emp_no;
