第三章 9-自外连接 self outer joins--Mosh mySQL

1.之前我们学习了自连接

现在学习自外连接

use sql_hr;
select
e.employee_id,
e.first_name,
m.first_name as manager
from employees e
join employees m
on e.reports_to=m.employee_id

2，如果现在的，加上left就会出现Yovonnda null的记录

use sql_hr;
select
e.employee_id,
e.first_name,
m.first_name as manager
from employees e
left join employees m
on e.reports_to=m.employee_id