If
Did
is a PK in
dept
table and
FK
in employee table,
INNER
clause should looks like:
FROM dept LEFT JOIN employee ON dept.Did = employee.Did
It mean: fetch all data from
dept
table and metches records from
employee
table
The rest of query try to write yourself.