父查询有Null值

一个部门表有部门主管编号，外键，与员工表的员工编号构成外键约束

想要查找部门主管的名字，
刚开始想半天
先想到2条SQL查询语句

SELECT
        dno,department.department,business,employee.name as manager
        FROM
        department,employee
        WHERE
        department.mid IS NOT NULL
        AND department.mid = employee.id;

        SELECT
        dno,department.department,business
        FROM
        department
        WHERE
        department.mid IS NULL;

最后想到上课讲过的外连接，这次运用左外连接
leftjoin
ok 问题解决

SELECT
        dno,department.department,business,employee.name as manager
        FROM
        department LEFT JOIN employee ON department.mid = employee.id