Re:Our SQL interview questions
by jacques_chester on Tuesday May 28, 2013 @09:00AM
(#5779673)
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.
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.