MYSQL:

select last_name,first_name,dept_no
from employees left join dept_emp
on employees.emp_no=dept_emp.emp_no;

 

posted on 2021-10-12 08:18  Sempron2800+  阅读(51)  评论(0编辑  收藏  举报