|
|
|
|
|
|
by jacques_chester
4763 days ago
|
|
|
The empty department remark is the clue. They want all departments; if it's an empty department they still want to see that it's an empty department. An inner join will hide that row because there's no equality between a set (departments) and an empty set (employees in that dept, of which there are none). A correctly structured outer join will. |
|
|