Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: